Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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

  • Hyperbolic Sine. See SINH Function.
  • Hyperbolic Cosine. See COSH Function.
  • Hyperbolic Tangent. See TANH Function.
  • Hyperbolic Cotangent. Computed as 1/TANH.
  • Hyperbolic Secant. Computed as 1/COSH.
  • Hyperbolic Cosecant. Computed as 1/SINH. 

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
Parameter: Formula type Single row formula
Parameter: Formula round(radians(X), 3)
Parameter: New column name 'rX'

Hyperbolic Sine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(sinh(rX), 3)
Parameter: New column name 'SINHrX'

Hyperbolic Cosine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(cosh(rX), 3)
Parameter: New column name 'COSHrX'

Hyperbolic Tangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(tanh(rX), 3)
Parameter: New column name 'TANHrX'

Hyperbolic Cotangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, tanh(rX)), 3)
Parameter: New column name 'COTHrX'

Hyperbolic Secant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, cosh(rX)), 3)
Parameter: New column name 'SECHrX'

Hyperbolic Cosecant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, sinh(rX)), 3)
Parameter: New column name 'CSCHrX'


Results:

XrXTANHrXCOTHrXCOSHrXSECHrXSINHrXCSCHrX
-30-0.524-0.481-2.0791.140.877-0.548-1.825
000null110null
300.5240.4812.0791.140.8770.5481.825
450.7850.6561.5241.3240.7550.8681.152
601.0470.7811.281.60.6251.2490.801
901.5710.9171.0912.510.3982.3020.434
1202.0940.971.0314.120.2433.9970.25
1352.3560.9821.0185.3220.1885.2270.191
1803.1420.9961.00411.5970.08611.5530.087

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 1 rates

This page has no comments.