EXAMPLE - Numeric Functions

This example demonstrate the following numeric functions:

Source:

ValueAValueB
82
104
1510
56

Transform:

Execute the following transforms:

derive value:ADD(ValueA, ValueB) as:'add'

derive value:SUBTRACT(ValueA, ValueB) as:'subtract'

derive value:MULTIPLY(ValueA, ValueB) as:'multiply'

derive value:DIVIDE(ValueA, ValueB) as:'divide'

derive value:MOD(ValueA, ValueB) as:'mod'

derive value:NEGATE(ValueA) as:'negativeA'

Results:

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

ValueAValueBnegativeAmoddividemultiplysubtractadd
82-80416610
104-1022.540614
1510-1551.5150525
56-550.83333333330-111
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation