Page tree

Trifacta Dataprep


Contents:

On January 27, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

 

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

This page has no comments.