Compare two files

[CLefrançois1698687128]

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]

Hi

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

Regards

Shong

[msjian]

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