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 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
  • Second "Is Equal To" checks if Sequence value is 2 and if it is it passes the name to the next step

Transformation Editor

Direct link, no registration required.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies