Page tree

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

Compare with Current View Page History

« Previous Version 37 Next »

Trifacta SaaS



Contents:

   

This example illustrates how to apply the inverse trigonometric (Arc) functions to your transformations. 

Functions:

ItemDescription
$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

Also:

ItemDescription
$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.


NOTE: These functions are valid over specific ranges.

The following functions are computed using the above functions.

  • Arccotangent. Computed using ATAN function. See below.
  • Arcsecant. Computed using ACOS function. See below.
  • Arccosecant. Computed using ASIN function. See below.

Source:

In the following sample, input values are in radians. In this example, all values are rounded to two decimals for clarity.


Y
-1.00
-0.75
-0.50
0.00
0.50
0.75
1.00

Transformation:

Arcsine:

Valid over the range (-1 <= Y <= 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(degrees(asin(Y)), 2)
Parameter: New column name 'asinY'

Arccosine: 

Valid over the range (-1 <= Y <= 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(degrees(acos(Y)), 2)
Parameter: New column name 'acosY'

Arctangent: 

Valid over the range (-1 <= Y <= 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(degrees(atan(Y)), 2)
Parameter: New column name 'atanY'

Arccosecant:

This function is valid over a set of ranged inputs, so you can use a conditional column for the computation. 

Transformation Name Conditional column
Parameter: Condition type if...then...else
Parameter: If (Y <= -1) || (Y >= 1)
Parameter: Then round(degrees(asin(divide(1, Y))), 2)
Parameter: New column name 'acscY'

Arcsecant:

Same set of ranged inputs apply to this function. 

Transformation Name Conditional column
Parameter: Condition type if...then...else
Parameter: If (Y <= -1) || (Y >= 1)
Parameter: Then round(degrees(acos(divide(1, Y))), 2)
Parameter: New column name 'asecY'

Arccotangent:

For this function, the two different ranges of inputs have different computations, so an else condition is added to the transformation. 

Transformation Name Conditional column
Parameter: Condition type if...then...else
Parameter: If Y > 0
Parameter: Then round(degrees(atan(divide(1, Y))), 2)
Parameter: Else round(degrees(atan(divide(1, Y)) + pi()), 2)
Parameter: New column name 'acotY'

Results:

YacotYasecYacscYatanYacosYasinY
-1.00-41.86180.00-90.00-45.00180.00-90.00
-0.75-49.99nullnull-37.00139.00-49.00
-0.50-60.29nullnull-27.00120.00-30.00
0.00nullnullnull0.0090.000.00
0.5063.44nullnull27.0060.0030.00
0.7553.13nullnull37.0041.0049.00
1.0045.000.0090.0045.000.0090.00

See Also for EXAMPLE - Trigonometry Arc Functions:

Error rendering macro 'contentbylabel'

parameters should not be empty

  • No labels

This page has no comments.