This example demonstrates how to compare records in two different files
The result file has only new or changed records.

Download and install Advanced ETL Processor
https://www.etl-tools.com/advanced-etl-processor-enterprise/overview.html

1. Create a new transformation and open .ats file
2. Double click on the Reader object and amend source file path
3. Double click on the Writer object and amend target file path leaving the calculation intact
4. Double click on trasmormation 1, double click on lookup and amend the file path
5. Press green arrow to run the transformation

Questions?
Ask them here
https://www.etl-tools.com/support/support-forum.html

https://www.etl-tools.com