Forum Discussion

haraldjw's avatar
haraldjw
Frequent Visitor
5 years ago
Solved

How to extract XML-information from a column in SQL-database

Who can help me with the following?   In a SQL-database the table Invoice contains the field Invoice, with multiple rows in XML-information.   My question: How can I extract the column as a separ...
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    Hello haraldjw ,

     

    Try parsing the Invoice column as xml in Power Query Editor as below:

    You can then expan the column and select the attributes as per your requirement as below:

    Hope this works for you.

PC2790's avatar
PC2790
Community Champion
5 years ago

Hello haraldjw ,

 

Try parsing the Invoice column as xml in Power Query Editor as below:

You can then expan the column and select the attributes as per your requirement as below:

Hope this works for you.

  • haraldjw's avatar
    haraldjw
    Frequent Visitor
    5 years ago

    You're a hero, PC2790 Impactful Individual!

     

    That's it.

     

    Found my way into XML in SQL and learned new things.

     

    Thanx a lot!