Merging to specific Rows

Hi all, new KNIME user and learning fast.

Am stuck on one issue, on how to loop through the merge specific Rows.

My example:

Data Source for loop
Row 1
Source1
Source2
Source3
Source4

Data Table
Row 1|Row 2
A | Source1
B | Source1
C | Source1
D | Source1
E | Source1
A | Source2
B | Source2
C | Source2
A | Source3
B | Source4
C | Source4
D | Source4

The output i am looking for:

Row 1 | Row 2
A,B,C,D,E | Source1
A,B,C | Source2
A | Source3
B,C,D | Source4

Any help, greatly appreciated.

Hi @stu_shepherd,

I guess you have the same problem as the user in this thread.
Cheers,
Johannes

2 Likes

Ah perfect thank you… just needed that foot in the door to figure out the rest.

Thank you again :slight_smile:

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