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.