Merge/Combine rows from different columns

Dear all,

i have joined two tables and this is my output:

1

Now i want to have an output like this (maybe columnd A already merged):

2

Which node i can use for this purpose?

BR

ogon

@ogon,

For this purpose you might think of using the Joiner Node https://nodepit.com/node/org.knime.base.node.preproc.joiner.Joiner2NodeFactory
Use the table as input for both the left and right hand table. Then define an inner join between column 1 and 3.
Unfortunately the output is not 100% what you would expect: The names of your Column 4 is different and (your) Column 3 will be empty.
But maybe that will help to solve your job.

2 Likes

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