Forum Discussion

SamTrexler's avatar
SamTrexler
Helper IV
9 years ago
Solved

Extracting data from multiple XML files

I'm following the method in http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/ to extract fields from multiple XML files in a directory structure, and it works great. I've crea...
Need Help
  • AlexChen's avatar
    AlexChen
    9 years ago

    Hi,

     

    I changed my xml to make my returned columns looks similiar as yours.

     

     

    Formula Query4:

     

    Query3 without invoking Query4:

     

    This is the result:

     

     

    Query3 invoking Query4:

    This is the result:

     

     

    Query4 works well in my local. The second column's name has updated to "init-param".

    So I hope you can change your parameter of Query4 to table and try again.

     

    Best Regards

    Alex

AlexChen's avatar
AlexChen
Microsoft Employee
9 years ago

Hi,

 

I changed my xml to make my returned columns looks similiar as yours.

 

 

Formula Query4:

 

Query3 without invoking Query4:

 

This is the result:

 

 

Query3 invoking Query4:

This is the result:

 

 

Query4 works well in my local. The second column's name has updated to "init-param".

So I hope you can change your parameter of Query4 to table and try again.

 

Best Regards

Alex

SamTrexler's avatar
SamTrexler
Helper IV
9 years ago

AlexChen, it works perfectly now. I know I tested with Query4 taking a table as a parameter - even as recently as yesterday. I'm not sure what's changed, but it's working now with the help you've given. Thanks so much.