Below is an example of a complex data transformation we have done for one of our customers
Source File

The desired result of the transformation

It is rather a complicated example and it gives a very good demonstration of software abilities
- Data flows from the left to the right
- Data reader reads the data
- it ignores the number of header columns since we do not need them
- Data Validator removes empty lines
- Data Transformer 1 extracts the columns we need
- Data transformer 2 helps us to calculate values distributed in several rows.
We use a combination of the Sequence number +calculation function
The sequence number is reset back to 1 when the product number changes,
so when sequence number =1 then we have min value when 2 max value etc - Next, we use data grouper to get the last line from the group and
- last data transformer for the actual mapping
Data transformation Screenshots
Click on thumbnail to see the screenshot
Direct link, no registration required.