Converting columns to rows in knime

KNIME Analytics Platform
1

Hi,

I would like to convert all the columns in my table into rows grouped by my id column. Say for example I have the following table:

ID a1 a2
1 2 4
2 4 6
3 3 5

I need to convert it into the following table

ID a value
1 1 2
1 2 4
2 1 4
2 2 6
3 1 3
3 2 5

Is there any way I can do this in Knime. I tried the Pivot node but with no success. 

Your help is much appreciated!

Thanks,

 

2

Hi,

try the Unpivoting node instead. Use a1 and a2 as value columns and your ID column as a retained column, unless it's the rowID column, then just leave retained columns empty.

3

Thanks! It worked