Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
@Claude Lefrançois , can you show us an example of files? We will see which one is the best approach.
Regards
Shong
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