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 | ||
|
|
More complex transformation example:
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