topic tMap One to many join not working - what am I doing wrong in Talend Studio

tMap One to many join not working - what am I doing wrong

1636848613 — Fri, 15 Nov 2024 23:19:48 GMT

I have a table of unique ProductIDs, and another table with multiple values for the ProductID. When I use the tMap component and join it on this field and update the Match Model to "All matches" it is still only returning a single entry from the second table.

Can someone please enlighten me as to what I am doing wrong.

Thanks

Re: tMap One to many join not working - what am I doing wrong

BChaubey — Sun, 09 Jan 2022 08:47:38 GMT

Please check the data

Re: tMap One to many join not working - what am I doing wrong

1636848613 — Mon, 10 Jan 2022 04:09:45 GMT

I couldnt see any data issue, but clearly were some. Rebuilt table and all appears to be working again.