Keep Value Data Transformation Function

The keep value stores previous not null value the field. This sounds very simple but it can help with very complex data transformation

Example:

Source Result of transformation

Keep Value Data Transformation Function

           

Keep Value Data Transformation Function Result

More complex transformation example:

Keep Value Data Transformation Function Result

Invoice number and Invoice date can be easily extracted by combining Sequence, Is Equal To and Keep value functions.

  • Record number 1 holds the Order number and
  • Record 2 holds Order Date
  • Fist "Is Equal To" checks if the Sequence value is 1 and if it is it passes the name to the next step
  • The second "Is Equal To" checks if the Sequence value is 2 and if it is it passes the name to the next step

Transformation Editor

Direct link, no registration required.