Pivoting Help

Options
Isaiah02
Isaiah02 Member
in Magic ETL

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!

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    You would use the Unpivot Tile and configure it like this:

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

Categories