##### Page tree

You are viewing an old version of this page. View the current version.

Version 22

Trifacta Dataprep

Contents:

This example illustrates how to apply basic trigonometric functions to your transformations. All of the functions take inputs in radians.

Source:

In the following sample, input values are in degrees:

X
-30
0
30
45
60
90
120
135
180

Transformation:

In this example, all values are rounded to three decimals for clarity.

First, the above values in degrees must be converted to radians.

Transformation Name `New formula` `Single row formula` `round(radians(X), 3)` `'rX'`

Sine:

Transformation Name `New formula` `Single row formula` `round(sin(rX), 3)` `'SINrX'`

Cosine:

Transformation Name `New formula` `Single row formula` `round(cos(rX), 3)` `'COSrX'`

Tangent:

Transformation Name `New formula` `Single row formula` `round(tan(rX), 3)` `'TANrX'`

Cotangent:

Transformation Name `New formula` `Single row formula` `round(1 / tan(rX), 3)` `'COTrX'`

Secant:

Transformation Name `New formula` `Single row formula` `round(1 / cos(rX), 3)` `'SECrX'`

Cosecant:

Transformation Name `New formula` `Single row formula` `round(1 / sin(rX), 3)` `'CSCrX'`

Results:

XrXCOTrXSECrXCSCrXTANrXCOSrXSINrX
-30-0.524-1.731.155-1.999-0.5780.866-0.5
00null1null010
300.5241.731.1551.9990.5780.8660.5
450.7851.0011.4141.4150.9990.7070.707
601.0470.5781.9991.1551.7310.50.866
901.5710-4909.8261-4909.82601
1202.094-0.577-2.0011.154-1.734-0.50.866
1352.356-1-1.4141.414-1-0.7070.707
1803.1422454.913-1-2454.9130-10

• No labels

This page has no comments.