Data manipulation

KNIME Analytics Platform
1

Hi there,
I am asking for help in building a workflow that does the following data manipulation:

My original file has the following structure:
Col1 Col2
ID Amadeus
SR Mozart
I1 Test_AM
I1 Test2_AM
IZ Final_AM
ID Giuseppe
SR Verdi
I1 Test_GV
I2 Info_GV
I3 Data_GV
IZ Final_GV
ID Richard
SR Wagner
I2 Info_RW
I2 Info2_RW
IZ Final_RW
…

The manipulation should lead to the following:
ID SR I1 I2 I3 IZ
Amadeus Mozart [Test_AM,Test2_AM] ? ? Final_AM
Giuseppe Verdi Test_GV Info_GV Data_GV Final_GV
Richard Wagner ? [Info_RW, Info2_RW] ? Final_RW

Is there a way to do this with KNIME?
Thanks a lot
Arianna

2

Hi, So far the Pivot node is not able to perform this kind of operation, sorry. But the workaround is pretty easy by using the following nodes: Read in your data, GroupBy column “Col1”, use the RowID node to put “Col1” as row ID, use the Cell Splitter the split up “Col2” again, remove the original column “Col2” and Transpose the table. Voilà. Best, Thomas

3

Hi,

Nice Solution and that would be a great feature for the Pivot Node wishlist.

Best regards,

Jay

4