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


Compare records in two files


Lookup properties

Validation Editor

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

Visit ETL Tools Forum