Table Layout, Parent ID/ Child ID

Hey there,
so I’ve got a table like this:
Table%201

and i want it to look like this:
Table%202

Is there a way to do that in Knime?

Sure there is!

Split columns, group by repeating data, concatenate, sort, replace missing values and that’s it :wink:

Here is workflow.

Table layout.knwf (14.0 KB)

Br,
Ivan

Thank you Ivan! Thats what im looking for :wink:

You are welcome :wink:
Ivan

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