You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Join on delimited files
Post a reply
Topic review (newest first)
- spotp999
- 2012-07-13 16:06:19
Thanks a lot.
Regards,
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-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