Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Not Getting XML Data In Power Query Properly

Hi All,

 

When i am importing data from from web and that has value in XML, the headers are showing in a column and not as headers. The value are repeatitive because it is for ever device so can not use Pivot. Just next to that column there is column which has information for these headers. Please if anyone can help. I am stuck on this for 3 days now.

 

 

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

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    If you can share a sample XML file and the expected results in an Excel sheet, then it would it much easier to solve.


    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy 

       

      Thanks for quick response. I am getting data from a link which has data in XML (Attached). Also attached how it it visible in Power Query and how i want. Appriciate your help.

       

      It has data for many devices so these Attribute.ID are repeating.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

         

        Try to use the Transpose function to turn your rows into columns and your columns into rows.

         

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.