Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

The following example demonstrates how the exponential functions work together. These functions include the following:

Source:

rowNumX
1-2
21
30
41
52
63
74
85

Transformation:


Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula EXP (X)
Parameter: New column name 'expX'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula LN (expX)
Parameter: New column name 'ln_expX'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula LOG (X)
Parameter: New column name 'logX'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula POW (10,logX)
Parameter: New column name '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

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 11 rates

This page has no comments.