Magic ETL

Magic ETL

Pivoting Help

I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data.

image.png

in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as well as removing the Null values.

Any help is appreciated. Thanks!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

Answers

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In