Hello KNIME World
Have little experience with KNIME and would like advise on which node(s) to use to accomplish the following mini-task without resorting to using R, Python etc,.
I have a table that represents a one-to-many relation. Here’s a toy example,
c1 c2
1 A
2 B, C, D
3 E
Using KNIME, I would like to re-organise the data like this
c1 c2
1 A
2 B
2 C
2 D
3 E
Any pointers appreciated. I tried a number of nodes but so far did not find a solution.
Thanks,
Sean