Use of Pivoting or Unpivoting

Hi all, I have a simple question about the application of the pivot node (if this node is the right one…) and its correct use with an example.

In the file “Pivot - Input Table” the entries are arranged crosswise. My wish is to rotate them (see picture) and Create Column A with Name “Periode”.

Input Table
Pivoting.xlsx (10.9 KB)


Thanks in advance :slight_smile:

hi @ARock1980,

what you need is the Unpivoting — NodePit

It should be configured like that…

Afterwards you may rename the columns and filter them.

best regards, Tommy


Hi @tommy, thanks for your quick reply and your help with my first steps with Knime :slight_smile:


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