EXP Function

Computes the value of e raised to the specified power. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

• e or Euler's Number is the value that the following equation approaches as n grows large: (1 + (1/ n)) n .

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:

exp(1)

Output: Returns the value of e1, which is approximately 2.718281828.

Column reference example:

exp(MyValue)

Output: Returns the value of e to the power of the value in the MyValue column.

Syntax and Arguments

exp(numeric_value)

Argument

Required?

Data Type

Description

numeric_value

Y

string, decimal, or integer

Name of column or Decimal or Integer literal to apply to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

numeric_value

Name of the column or numeric literal whose value is the exponent of e.

• 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 Type

Example Value

Yes

String (column reference) or Integer or Decimal literal

2.3

Examples

Sugerencia

Example - Exponential functions

This example demonstrates the exponential functions.

Functions:

Item

Description

EXP Function

Computes the value of e raised to the specified power. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

LN Function

Computes the natural logarithm of an input value. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

LOG Function

Computes the logarithm of the first argument with a base of the second argument.

POW Function

Computes the value of the first argument raised to the value of the second argument.

Source:

rowNum

X

1

-2

2

1

3

0

4

1

5

2

6

3

7

4

8

5

Transformation:

 Transformation Name New formula Single row formula EXP (X) 'expX'
 Transformation Name New formula Single row formula LN (expX) 'ln_expX'
 Transformation Name New formula Single row formula LOG (X) 'logX'
 Transformation Name New formula Single row formula POW (10,logX) 'pow_logX'

Results:

In the following, (null value) indicates that a null value is generated for the computation.

rowNum

X

expX

ln_expX

logX

pow_logX

1

-2

0.1353352832366127

-2

(null value)

(null value)

2

-1

0.1353352832366127

-0.9999999999999998

(null value)

(null value)

3

0

1

0

(null value)

0

4

1

2.718281828459045

1

0

1

5

2

7.3890560989306495

2

0.30102999566398114

1.9999999999999998

6

3

20.085536923187668

3

0.47712125471966244

3

7

4

54.59815003314423

4

0.6020599913279623

3.999999999999999

8

5

148.41315910257657

5

0.6989700043360187

4.999999999999999