topic Re: Comparing 2 flat files and getting the unmatched records in a .csv file in Data Quality

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

Anonymous — Sat, 16 Nov 2024 06:54:48 GMT

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 — Tue, 08 Jan 2019 21:00:47 GMT

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