Merge multiple XML files (with same layout) into 1 merged XML file (addition of data needed)
Hi, I don't have any experience with XML and I don't seem to have found any other discussion that could help me further. I would like to combine multiple XML files that have exactly the same lay-out but different data (different multiple amounts) into 1 file that keeps the original layout but adds up the amounts of the different data rows. My idea was to use power query on the folder where I will monthly download the individual XML files, automate the merging process including the necessary additions and export the 'merged' XML file. Is that possible and if yes any instructions on how I could do this? What would be the necessary steps in setting this up? Thank you in advance!