Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 39 Current »

Trifacta Dataprep



Contents:

   

This example demonstrates how to use numeric functions to perform computations in your recipe steps.

Functions:

ItemDescription
$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

Source:

ValueAValueB
82
104
1510
56

Transformation:

Execute the following transformation steps:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula ADD(ValueA, ValueB)
Parameter: New column name 'add'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula SUBTRACT(ValueA, ValueB)
Parameter: New column name 'subtract'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MULTIPLY(ValueA, ValueB)
Parameter: New column name 'multiply'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DIVIDE(ValueA, ValueB)
Parameter: New column name 'divide'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MOD(ValueA, ValueB)
Parameter: New column name 'mod'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula NEGATE(ValueA)
Parameter: New column name 'negativeA'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula LCM(ValueA, ValueB)
Parameter: New column name 'lcm'

Results:

With a bit of cleanup, your dataset results might look like the following:

ValueAValueBlcmnegativeAmoddividemultiplysubtractadd
828-80416610
10420-1022.540614
151030-1551.5150525
5630-550.83333333330-111

See Also for EXAMPLE - Numeric Functions:

Error rendering macro 'contentbylabel'

parameters should not be empty

  • No labels

This page has no comments.