##### Page tree

Trifacta SaaS

Contents:

This example demonstrates the exponential functions.

Functions:

ItemDescription
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:

rowNumX
1-2
21
30
41
52
63
74
85

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.

rowNumXexpXln_expXlogXpow_logX
1-20.1353352832366127-2(null value)(null value)
2-10.1353352832366127-0.9999999999999998(null value)(null value)
3010(null value)0
412.718281828459045101
527.389056098930649520.301029995663981141.9999999999999998
6320.08553692318766830.477121254719662443
7454.5981500331442340.60205999132796233.999999999999999
85148.4131591025765750.69897000433601874.999999999999999