Date: Sun, 16 Jan 2022 18:24:44 +0000 (GMT) Message-ID: <226060457.105174.1642357484289@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_105173_2010893370.1642357484289" ------=_Part_105173_2010893370.1642357484289 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html EXAMPLE - RANDBETWEEN and PI Functions

EXAMPLE - RANDBETWEEN and PI Functions

This example illustrates how you can apply the following functio= ns to generate new and random data in your dataset:

• RANDBETWEEN - Generate a random Integer value between two = specified Integers. See RAND= BETWEEN Function.
• PI - Generate the value of pi to 15 decimal points. See PI Function.
• ROUND - Round a decimal value to the nearest Integer or to= a specified number of digits. See ROUND Function.
• TRUNC - Round a value down to the nearest Integer value. S= ee TRUNC Function.

Source:

In the following example, a company produces 10 circular parts, the size= of which is measured in each product's radius in inches.

=20 =20 =20
p001 1
p002 2
p003 3
p004 4
p005 5
p006 6
p007 7
p008 8
p009 9
p010 10

Based on the above data, the company wants to generate some additional s= izing information for these circular parts, including the generation of two= points along each part's circumference where quality stress tests can be a= pplied.

Transform:

To begin, you can use the following steps to generate the area and circu= mference for each product, rounded to three decimal points:

=20

derive type:single value: ROUND(PI()= * (POW(radius_in, 2)), 3) as: 'area_sqin'

=20

derive type:single value: ROUND(PI()= * (2 * radius_in), 3) as: 'circumference_in'

For quality purposes, the company needs two tests points along the circu= mference, which are generated by calculating two separate random locations = along the circumference. Since the RANDBETWEEN function only c= alculates using Integer values, you must first truncate the values from circumference_in:

=20

derive type:single value: TRUNC(circ= umference_in) as: 'trunc_circumference_in'

Then, you can calculate the random points using the following:

=20

derive type:single value: RANDBETWEE= N(0, trunc_circumference_in) as: 'testPt01_in'

=20

derive type:single value: RANDBETWEE= N(0, trunc_circumference_in) as: 'testPt02_in'

Results:

After the trunc_circumference_in column is dropped, the dat= a should look similar to the following:

=20 =20 =20 =20 =20 =20 =20
prodId radius_in area_sq_in circumference_in testPt01_in testPt02_in
p001 1 3.142 6.283 5 5
p002 2 12.566 12.566 3 3
p003 3 28.274 18.850 13 13
p004 4 50.265 25.133 24 24
p005 5 78.540 31.416 0 0
p006 6 113.097 37.699 15 15
p007 7 153.938 43.982 11 11
p008 8 201.062 50.265 1 1
p009 9 254.469 56.549 29 29
p010 10 314.159 62.832 21 21
------=_Part_105173_2010893370.1642357484289--