Hi everyone,
I am trying to group by some data, but I cannot obtain the result I need. My problem will be easier to explain with an example:
Let's say I have two columns, each contains the IDs of a book in two different bookshops.
ID_shop1 ID_shop2
A 1
A 2
B 2
A, B, 1 and 2 represent the same book. I can use the 'groupby' node and concatenate to get:
A 1, 2
B 2
Now I would like to have this result:
A, B 1, 2
Is it possible to do this with Knime?
I would be really grateful for any help/ideas,
Lau