How to correctly pivot this data?

Options
gbrown
gbrown 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:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @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

  • MichelleH
    MichelleH Coach
    Options

    @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.

  • gbrown
    gbrown Member
    Options

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

    image.png

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @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.

Categories