Second, Third value in a join? similar to index match in outlook

KNIME Extensions
1

HI I’ve got a table,

i’m trying to acheive from below:

Name Item
BOB 1
BOB 2
JOHN 1
JOHN 2
MATHEW 2
BOB 3
MATHEW 1

so I have an output of:

bob 1 3 2
Mathew 2 1

It doesn’t matter what order the numbers are in, just next them in the same row of data.

any ideas?
Yes i’ve searched, googled, tried different things, but i’m stuck. I don’t know much coding, however I do realise that that could be a potential solve.

Thank you very much for your time & assistance.

2

Use Group by node for grouping on Name and aggregating using list function
then create separate columns using

2 Likes
3

Fantastic, that is brilliant. I filtered out other rows so i just had the two i need, then joined them back up, just fantastic. Thank you so much

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.