Pivoting/Unpivoting Row Values to Columns


I am struggling with changing some rows in my data into columns. I believe it could be done with the pivoting node but I am not able to put in the right configuration in the node to achieve what I want.

This is how the data looks like:


And this is the transformation I am looking for:


Would you please help me on how to achieve that?

Thanks a lot.

Hi @amrzahran,

assuming Material, Plant and Week are your key columns set these as Group columns, MRP Element as Pivot column and Quantity as Manual Aggregation column.
The aggregation mode depends on you data you can set first, sum, minimum, etc.
Under Advanced setting set Column name to ‘Pivot name’ and Aggregation name as ‘Keep original name(s)’


1 Like

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