Date: Sat, 29 Jan 2022 00:47:17 +0000 (GMT) Message-ID: <1237648490.127490.1643417237620@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_127489_54413309.1643417237620" ------=_Part_127489_54413309.1643417237620 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 functions to generate ra= ndom numeric data in your dataset.

Functions:

=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Item Description
RANDBETWEEN Function Generates a random integer between a low and a = high number. Two inputs may be Integer or Decimal types, functions ret= urning these types, or column references.
PI Function The PI function generate= s the value of pi to 15 decimal places: 3.1415926535897932.
ROUND Function Rounds input value to the nearest integer. = ;Input can be an Integer, a Decimal, a column reference, or an express= ion. Optional second argument can be used to specify the number of dig= its to which to round.
TRUNC Function Removes all digits to the right of the decimal = point for any value. Optionally, you can specify the number of digits to wh= ich to round. Input can be an Integer, a Decimal, a column reference, = or an expression.
POW Function Computes the value of the first argument = raised to the value of the second argument.

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.

Transformation:

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

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(PI() * (POW(radius_in, 2)), 3) 'area_sqin'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ROUND(PI() * (2 * radius_in), 3)=20 'circumference_in'
=20

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
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula TRUNC(circumference_in) 'trunc_circumference_in'
=20

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

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula RANDBETWEEN(0, trunc_circumference_in) 'testPt01_in'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula RANDBETWEEN(0, trunc_circumference_in) 'testPt02_in'
=20

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

=20
=20