##### Page tree

Outdated release! Latest docs are Release 8.7: TANH Function

Computes the hyperbolic tangent of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

A hyperbola is the shape created by taking a planar slice of two cones whose tips are touching each other. For two identical cones, the curves of the slices mirror each other, no matter the angle of the plane through the cones.

• The two slices represent the set of points on a grid such that:

where k is some constant.

• The hyperbolic trigonometric functions measure trigonometric calculations for the right-side (x > 0) slice of the hyperbola.

The hyperbolic tangent (TANH) function is computed using the following formula:

Hyperbolic cotangent:

The hyperbolic cotangent is the following:

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

## Basic Usage

Numeric literal example:

Output: Returns the computation of the hyperbolic tangent of a 30-degree angle, which is converted to radians before being passed to the TANH function. The output value is rounded to three decimals: 0.548.

Column reference example:

tanh(X)

Output: Returns the hyperbolic tangent of the radians values in X column.

## Syntax and Arguments

tanh(numeric_value)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column, Decimal or Integer literal, or function returning those types to apply to the function

### numeric_value

Name of the column, Integer or Decimal literal, or function returning that data type to apply to the function.

• Missing input values generate missing results.
• Literal numeric values should not be quoted. Quoted values are treated as strings.
• Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal0.5

## Examples

### Example - Hyperbolic trigonometry functions

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 Single row formula round(radians(X), 3) 'rX'

Hyperbolic Sine:

Transformation Name New formula Single row formula round(sinh(rX), 3) 'SINHrX'

Hyperbolic Cosine:

Transformation Name New formula Single row formula round(cosh(rX), 3) 'COSHrX'

Hyperbolic Tangent:

Transformation Name New formula Single row formula round(tanh(rX), 3) 'TANHrX'

Hyperbolic Cotangent:

Transformation Name New formula Single row formula round(divide(1, tanh(rX)), 3) 'COTHrX'

Hyperbolic Secant:

Transformation Name New formula Single row formula round(divide(1, cosh(rX)), 3) 'SECHrX'

Hyperbolic Cosecant:

Transformation Name New formula Single row formula round(divide(1, sinh(rX)), 3) '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