This example shows how to compare records in two different files and only include changed or new records

ETL Example

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new transformation and open .ats file
  • Double click on the Reader object and amend the source file path
  • Double click on the Writer object and amend the target file path leaving the calculation intact
  • Double click on transformation, double click on lookup and amend the file path
  • Press the green arrow to run the transformation
Screenshots

Compare records in two files

Transformation

Lookup properties

Validation Editor

There are other ways of transforming the data please contact us if you need help.

Visit ETL Tools Forum