Splited values and lookup ?

Hi everyone :)

I have a Column like that;







This Column type is string and  that numbers represent products id's. so i have another table and this table has productid and product name also.

So i want to convert that Column rows to product names like that

[apple, banana, milk]




What should i do? which nodes i need to use? i tryed several nodes like column splitter etc. but i did not handle this. as you can understand my data collection size can changed and  i need to find general solution.

thanks for your interest.

Hello bugra10ur,

I have attached a workflow that demonstrates how to do that.


Thank you !!!