Document toolboxDocument toolbox

Exponential: base e (exp)

Description

Returns the value of the constant e to the power of the values in a specified field.

How does it work in the search window?

Select Create column in the search window toolbar, then select the Exponential: base e operation. You need to specify two arguments:

Argument

Data type

Argument

Data type

Argument mandatory

integer, float

The data type of the values in the new column is float.


Example


We want to get the value e to the power of the numbers in the -1to1Values_float column of our table. To do it, we will create a new column using the Exponential: base e operation.

The arguments needed to create the new column are:

  • Argument -1to1Values_float column

Click Create column and you will see the following result:

How does it work in LINQ?

Use the operator select... as...  and add the operation syntax to create the new column. This is the syntax of the Exponential: base e operation:

  • exp(number)

Example

You can copy the following LINQ script and try the above example on the my.upload.sample.data table.

from my.upload.sample.data select split(message, ";", 16) as `-1to1Values` select float(`-1to1Values`) as `-1to1Values_float` select exp(`-1to1Values_float`) as exp_base_e