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.