Skip to content

    • SQL DataFlows

    SQL DataFlows

    How to correctly pivot this data?

    Member
    in SQL DataFlows

    I am trying to pivot the data below in an ETL flow. I am having trouble formmatting it correctly to PIVOT how I need.

    image.png

    I would like the following above to look like this after complete…

    image.png

    How could I do this?

    Thanks

    Tagged:

    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

    • Coach
      Answer ✓

      @gbrown I would suggest changing the format of the other dataset using the Dynamic Unpivot tile in MagicETL instead, if possible. You will have significantly more flexibility with the dataset when it is not already pivoted.

    Answers

    • Coach

      @gbrown You should be able to use your existing data as-is in a table card, and select the Transpose Columns option to put it in the desired format.

    • Member

      The problem is I am trying to append this data onto another dataset which is structured like this @MichelleH

      image.png
    • Coach
      Answer ✓

      @gbrown I would suggest changing the format of the other dataset using the Dynamic Unpivot tile in MagicETL instead, if possible. You will have significantly more flexibility with the dataset when it is not already pivoted.

    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

    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

    Quick Links

    Categories