Splited values and lookup ?

Hi everyone :)

I have a Column like that;

Column

[100,200,300]

[100]

[100,452,622]

[300,255,511,2121,200]

...

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]

[apple]

[apple,cofee,chocolate]

..

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.

Best,
Ferry

Thank you !!!