Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r080

This example demonstrate the following numeric functions:

Source:

ValueAValueB
82
104
1510
56

Transformation:

Execute the following transformation steps:

D trans
RawWrangletrue
p03Value'add'
Typestep
WrangleTextderive type:single value:ADD(ValueA, ValueB) as:'add'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueADD(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'subtract'
Typestep
WrangleTextderive type:single value:SUBTRACT(ValueA, ValueB) as:'subtract'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueSUBTRACT(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'multiply'
Typestep
WrangleTextderive type:single value:MULTIPLY(ValueA, ValueB) as:'multiply'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueMULTIPLY(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'divide'
Typestep
WrangleTextderive type:single value:DIVIDE(ValueA, ValueB) as:'divide'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueDIVIDE(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'mod'
Typestep
WrangleTextderive type:single value:MOD(ValueA, ValueB) as:'mod'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueMOD(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'negativeA'
Typestep
WrangleTextderive type:single value:NEGATE(ValueA) as:'negativeA'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueNEGATE(ValueA)
p03NameNew column name
SearchTermNew formula

D trans
RawWrangletrue
p03Value'lcm'
Typestep
WrangleTextderive type:single value:LCM(ValueA, ValueB) as:'lcm'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueLCM(ValueA, ValueB)
p03NameNew column name
SearchTermNew formula

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