My file 'x' has Different Ids coming in, and for each Id there can be 1 or more subIds. I need to update the name column in my file 'x' using lookup file 'y' based on y.subId=x.subId. But there is only one subId in each Id that will match the lookup. so every subId's name should be populated with the same lookup value for one particular Id.
All the Ids having 1 as value should update name as John. and so on
I have tried using Tmap. But couldn't do it. Pls help me find a way to achieve this
Most probably you must be using Unique match in tmap join condition. Could you please change it to All matches and see the result set.
If required, please also select Inner join instead of Left Outer join. But this condition is optional and it will be based on your specific use case.
If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema