topic Re: Compare two files in Data Quality

Compare two files

CLefrançois1698687128 — Fri, 15 Nov 2024 21:11:22 GMT

Good morning,

I'm new to talend.

I have two cvs files.

File 1 contains code and description.

File 2 contains several pieces of information including a column which contains codes.

What I want to do is check if file 2 contains codes from file 1.

I tried tMap and tRecordMatching but it doesn't work.

Anonymous — Tue, 12 Dec 2023 07:14:29 GMT

@Claude Lefrançois , can you show us an example of files? We will see which one is the best approach.

Regards

Shong

msjian — Mon, 04 Mar 2024 02:31:58 GMT

hello
you can design a job by using tRecordMatching .

first, you create 2 file delimited connections,

then create job as follows:
_80985 select your file1's code column,
row2.Column4 select your file2's code column

tlogrow will output the not match rows,
if there is 0 rows output, means all file 2 contains codes from file 1.

thanks
Jian