Pivotin or Unpivoting correct configuration

Hello everyone,
I have a simple question on the following topic…

Input Table

Question Pivoting_Unpivoting

Output Table

How must i configure the nods to get this result?
Question Knime.xlsx (26.7 KB)

Hello @ARock1980
From what we can see in your example: a GroupBy node would achieve the task.

Grouping on the first four columns and aggregate with Max. for the combined columns (in this specific case a Sum would work as well, as the combined value is zero)



There’s also the “Keep original names” option so you won’t have to rename the aggregation columns afterwards:


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