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 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

Download Advanced ETL Processor Enterprise now!

 

We have 805 guests and no members online