Unpivoting (correct configuration)

Hello all,

enclosed a question about the “unpivoting” node and configuration.

I have the following table:Unpivoting.xlsx (9.4 KB)

I want this result:

I use the following configuartion:

Probably it’s a beginner’s mistake :frowning: Anyway, thanks for your support!

Hello @ARock1980,

seems you are looking for Pivoting node :wink:

Regarding configuration - you don’t have grouping columns, pivoting column is Period and and First aggregation on Volume. Plus for Column name choose Pivot name to have intact period names.



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