Matching rows by rownumber in tMap

Anonymous — Mon, 15 Apr 2013 10:53:18 GMT

Hello,
I have a problem using tMap. The conditions are as follows:
I have 2 files: File X and File Y. They both contain an ID and a string field. The ID is not unique, there can be more that one entry for this ID. So it looks like this:
File X
|ID|Field|
|11|AAA|
|11|BBB|
File Y
|ID|Field|
|11|Azzz|
|11|Bzzz|
I am trying to match them in tMap to get a table like this:
|ID|Field|Field|
|11|AAA|Azzz|
|11|BBB|Bzzz|
I am matching them by the ID, the parameters are:
Lookup Model: Load Once
Match Model: Unique match
Join model: Left outer join
Store temp data: false
Instead, I get the table like this:
|ID|Field|Field|
|11|AAA|Bzzz|
|11|BBB|Bzzz|
I think I may use the row number together with the ID to match them. The row order in both files is always the same. How do I implement the row number for these fields?

Re: Matching rows by rownumber in tMap

Anonymous — Mon, 15 Apr 2013 12:16:35 GMT

Hi
Add a row number for each data flow and then do an inner join between them with the row number, remove the row number column after join, please see my screenshot to know how to add a row number.
Shong

topic Re: Matching rows by rownumber in tMap in Talend Studio

Matching rows by rownumber in tMap

Re: Matching rows by rownumber in tMap