locked
(4033 xml files) I would like to load to all xml files in to excel and extract all record in to one single excel files RRS feed

  • Question

  • (4033 xml files) i  need to clean the data and count the records of all files 

    So for that 

    I would like to merge all xml files in to one file (thats my first query How) 

    2nd 

    If would like to load to all xml files in to excel and extract all record in to one single excel files through power query how can I do it 

    Plz help me out 

    Regards 

    Saturday, November 3, 2018 10:55 PM

Answers

  • Hi there. Do all 4k xml files have the same format? If so, the first step would be to try importing one of them, to determine the steps needed to get the final result you're looking for. You can find examples of how to do this online. For example:

    https://www.howtoexcel.org/power-query/import-xml-files/

    The next step would involve turning this example query into a function. But for now, see if you can get one of the files imported.

    Ehren

    Thursday, November 8, 2018 9:09 PM