Hyperbolic tangent (tanh)
Description
Returns the hyperbolic tangent of the selected numeric field.
How does it work in the search window?
Select Create column in the search window toolbar, then select the Hyperbolic tangent operation. This operation needs only one argument:
Argument | Data type |
---|---|
Number mandatory | integer, float |
The data type of the new column is integer.
Example
In the my.upload.sample.data
table, let's calculate the hyperbolic tangent of the values column which contains numbers of data type integer.
Click Create column and select the Hyperbolic tangent operation. Select the numbers_int column as the argument and assign a name to the new column - let's call it simply numbers_int_tanh.
Click Create column and you will see the new tanH column containing float values.
How does it work in LINQ?
Use the operator select
... as
... to apply the Create column operation. These are the valid formats of the operation:
tanh(integer)
tanh(float)
Examples
Copy the following LINQ script and use it to replicate the previous example if you have uploaded the file.
from my.upload.sample.data
select split(message, ";", 17) as numbers,
int(numbers) as numbers_int
select tanh(numbers_int) as numbers_int_tanh