NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

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

Source File

mt_ignore

Desired result of transformation

mt_ignore

The hurdle with this report is the floating rows. Each material number may or may not have the same number of rows of information. Also, required information is on different lines - for example Min/Max stock level has 2 values on different rows on the input file and we need it to Transpose on output into 2 columns on the same row. Consumption is the same way.

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 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 on several rows.
    We use combination of Sequence number +calculation function
    Sequence number is reset back to 1 when product number changes,
    so when sequence number =1 then we have min value when 2 max value etc
  • Next we use data grouper to the get the last line from the group and
  • last data transformer for actual mapping

Data transformation Screenshots

Click on thumbnail to see the screenshot

Transformation Result Transformation Result Transformation Result Transformation Result Transformation Result
Transformation Result Transformation Result Transformation Result Transformation Result Transformation Result
Transformation Result Transformation Result Transformation Result Transformation Result Transformation Result
Transformation Result     

Visit Support Forum Learn More Download Buy It

We are here to help and we mean it

 Tutorials wiki dokuwiki 128 Hammer Spanner   help browser

Step-by-Step tutorials

Sharpen your skills by watching online tutorials and guides

Online Documentation

Read detailed online Wiki Documentation

Support Forum

Ask questions share ideas and discuss sulutions online

Contact Us

Use online contact form to ask questions

Could not find what you were looking for?   Just ask