Date: Sat, 15 May 2021 08:18:30 +0000 (GMT) Message-ID: <1842664675.8043.1621066710982@6a789edf488b> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8042_132467397.1621066710982" ------=_Part_8042_132467397.1621066710982 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 RANDBETWEEN 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.

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:

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 purpose= s, the company needs two tests points along the circumference, which are ge= nerated by calculating two separate random locations along the circumferenc= e. Since the  `RANDBETWEEN` function only calculates using Integer v= alues, 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 calculat= e 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, th= e data should look similar to the following:

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_8042_132467397.1621066710982--