How to Update multiple rows i.e. SubIds of a particular Id with same Lookup value which matches with only one subId

[Anonymous]

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

[Anonymous]

I have tried using Tmap. But couldn't do it. Pls help me find a way to achieve this

---

---

[Anonymous]

Hi,

     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 🙂

Warm Regards,

Nikhil Thampi