Page tree


Contents:

Our documentation site is moving!

For up-to-date documentation of Dataprep, please visit us at https://help.alteryx.com/Dataprep/.

   

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

Functions:

ItemDescription
ADD Function Returns the value of summing the first argument and the second argument. Equivalent to the + operator.
MOD Function Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the % operator.
NEGATE Function Returns the opposite of the value that is the first argument. Equivalent to the - operator placed in front of the argument.
SUBTRACT Function Returns the value of subtracting the second argument from the first argument. Equivalent to the - operator.
MULTIPLY Function Returns the value of multiplying the first argument by the second argument. Equivalent to the * operator.
DIVIDE Function Returns the value of dividing the first argument by the second argument. Equivalent to the / operator.
LCM Function Returns the least common multiple shared by the first and second arguments.

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:

This page has no comments.