Forum Discussion

cgkas's avatar
cgkas
Helper V
3 years ago
Solved

How to apply same query over multiple xml files?

Hi all,   I have a query that imports some specific nodes from a big nested xml file in power query for Excel. The query currently works for one xml and after parsing the XML, the ouput is placed i...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Try starting with the Folder connector (or better practice the SharePoint Folder connect and store the files in the cloud). Filter to just your xml files if needed, and then add a custom column with

     

    = Xml.Tables([Content]){1}[Table]

     

    I believe the column with the binary content is called Content (fix if not). You should then be able to expand out the data (assuming all the files have the same XML structure). If not, you can convert your original query into a function (with the binary content as the input), and use that instead.

     

    Pat

     

ppm1's avatar
ppm1
Solution Sage
3 years ago

Try starting with the Folder connector (or better practice the SharePoint Folder connect and store the files in the cloud). Filter to just your xml files if needed, and then add a custom column with

 

= Xml.Tables([Content]){1}[Table]

 

I believe the column with the binary content is called Content (fix if not). You should then be able to expand out the data (assuming all the files have the same XML structure). If not, you can convert your original query into a function (with the binary content as the input), and use that instead.

 

Pat