Comparing 2 flat files and getting the unmatched r... - Qlik Community

Anonymous · ‎2019-01-07

I need to compare 2 flat files and get the 6 extra records in a .csv file.

Count : flatfile1--->505726 records

flatfile2--->505720 records

Can anybody please help me as to how to design a talend job for the same in order to extract those 6 extra records.

yome1 · ‎2019-01-08

Hello,

The data in your two files are the same? but you have 6 extra rows in one?

For this you can inner join your two files into a tMap and get the rejected rows

Comparing 2 flat files and getting the unmatched records in a .csv file