Forum Discussion

infantpowerbi's avatar
infantpowerbi
Helper II
6 years ago

How to Unpivot the data for multiple duplicate columns

Dear All,


I am from Tableau background and my data is in Oracle DB is in below format  with different countires for different years and different quaters columns.
Can any one please help me how can I convert to unstructured data 

Unstructured Data

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi, can you explain a bit more about "A,B,C,D" in the table? if you don't use them, using Q3 2019 in replace of those fields can solve the problem. You can "unpivot" the data in "Edit Queries" in Power Bi.

     

    Regards,

      • ibarrau's avatar
        ibarrau
        Super User
        6 years ago

        Then I think you can merge those rows together like "A Q1 2018". Then you can do the transformation unpivot in Edit queries. This will generate a key value column. The key will be A Q1 2018 and the value the number of the table.

        After that you can continue the split column by first space if you want to separate application name from Q1 2018 in two columns.

         

        Hope this helps

        Regards,