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

[1636848613]

Hi

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

[BChaubey]

Please check the data

[1636848613]

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