You are not logged in.
Thanks a lot.
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.
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,