Talend community forum / Join on delimited files

spotp999 · 2012-07-12 20:40:53

Hi,
I am new to Talend and need your advice on the task I'm working on.

-> I have two delimited files - one larger tab delimited: field A | field B | field C |
-> smaller tab limited with: field A
-> I need to find entries in smaller file which are missing from the larger file by matching with the first field, field A. And write them to a file.

I'm using tFileInputDelimited to read the files. I think I need to user tMap to setup the join. Please advice on the querry I need to use do the join -- find entries in smaller file which are missing in larger file by matching with the field A.

Also how do I redirect the entries returned by the match to a file?

Thanks in advance,
Steve

alevy · 2012-07-13 02:07:58

Make the smaller file the main row and the larger file the lookup. Do an inner-join on field A and then select "catch inner join rejects" for the output flow to a tFileOutputDelimited. Read the tMap component help for scenarios.

spotp999 · 2012-07-13 16:06:19

Thanks a lot.
Regards,
Steve

Announcement

Unanswered posts

#1 2012-07-12 20:40:53

Join on delimited files

#2 2012-07-13 02:07:58

Re: Join on delimited files

#3 2012-07-13 16:06:19

Re: Join on delimited files

Board footer