Page tree



Contents:

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

This example demonstrate the following numeric functions:

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

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

This page has no comments.