ETL and Data Integration tools - Modern ETL software for everyone

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

Example:

More complex transformation example:

Data can be easily extracted by combining Sequence, Calculation and Keep value functions.

• Record number 1 holds Order number and
• Record 2 holds Order Date

Following calculation extracts relevant data based on the record number.

begin
if '[F001]' = '1' then
Result :='[F002]'
else
Result := '';    
end;