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 next

...

Example data:

XY
21
64
710
100

TransformsTransformations:


D trans
RawWrangletrue
p03Value'add'
Typestep
WrangleTextderive type:single value:(X + Y) as: 'add'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(X + Y)
p03NameNew column name
SearchTermNew formula

...

Info

NOTE: When a numeric operator is applied to a set of values, the type of data of each source value is re-inferred to match any literal values used on the other side of the expression. This method allows for more powerful comparisons.

In the following examples, values taken from the MySource column are re-typed to match the inferred data type of the other side of the expression.

add

Column TypeExample TransformTransformationOutputNotes
Integer/Decimal

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource + 5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource + 5)
SearchTermNew formula

Generated values are sum of values in MySource column and the constant (5 or 2.5).

 

 
DatetimeYou cannot directly add Datetime values. You can use the DATEDIF function to generate the number of days difference between two date values. See DATEDIF Function.  
String

You cannot add strings together.

  • You can use the MERGE transform to concatenate columns of string values together. See Merge Transform.
  • You can use the ARRAYCONCAT function to concatenate multiple columns of array type together. See ARRAYCONCAT Function.

 

 

 

For computational purposes, all data types not previously listed in this table behave like strings.

subtact

Column TypeExample TransformTransformationOutputNotes
Integer/Decimal

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource - 5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource - 5)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource - 2.5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource - 2.5)
SearchTermNew formula

Generated values are difference between values in   MySource   column and the constant (5 or 2.5). 
DatetimeYou cannot directly subtract Datetime values. You must use the DATEDIF function to generate the number of days difference between two date values. See DATEDIF Function.  
String

You cannot differentiate strings directly.

  • You can use the SUBSTRING function to locate one string within the other. If found, this function returns the index of the value in the source string where the substring is located. This index value can used as an input to the LEFT and RIGHT functions to remove the substring. See SUBSTRING Function.
 For computational purposes, all data types not previously listed in this table behave like strings.

...

multiply

Column TypeExample TransformTransformationOutputNotes
Integer/Decimal

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource * 5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource * 5)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource * 2.5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource * 2.5)
SearchTermNew formula

Generated values are the product of values in the MySource column and the constant (5 or 2.5). 
DatetimeN/A  
String

N/A

 

 

divide

Column TypeExample TransformTransformationOutputNotes
Integer/Decimal

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource / 5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource / 5)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource / 2.5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource / 2.5)
SearchTermNew formula

Generated values are the values in the MySource column divided by the constant (5 or 2.5).

 

 
DatetimeN/A  
String

N/A

 

 


modulo

Column TypeExample TransformTransformationOutputNotes
Integer

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource % 5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource % 5)
SearchTermNew formula

Generated values are the values in the MySource column divided by the constant (5 or 2.5).

 

 
Decimal

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:(MySource % 2.5)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(MySource % 2.5)
SearchTermNew formula

Not supported. Inputs must be of Integer type. 
DatetimeN/A  
String

N/A

 

 

...