Stacking of columns including column name

KNIME Analytics Platform
#1

Hello

I want to stack n columns in 1 and create a new one with the variable cokumn name.

So INPUT Table is:

Colum A Date 1 Date... Date n
X 01.01.2016   01.07.2018
Y 02.01.2016   02.07.2018

And OUTPUT table should be:

Column A Stacked date column New column
X 01.01.2016 Date 1
Y 02.01.2016 Date 1
  ... ..
X 01.07.2018 Date n
Y 02.07.2018 Date n

I have tried without success with column aggregator and ungroup nodes

Any suggestions ?

Thanks

 

#2

You need the unpivotig node.

Cheers, Iris

#3

It works !!!!

THANK YOU  IRIS

:-)