SQL DataFlows

SQL DataFlows

How to correctly pivot this data?

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

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

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

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

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

  • 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