Input Multiple XML Files

[rchua]

Hello. I'm looking to input multiple XML files with different columns/structures. I have 200 XML and when I load them all, almost are being skipped because majority did not have the same columns as with the first file it loaded. But the 200 XML file have columns that are in common. It's just that it's on a different position and some have more column than the other. I'm just looking to have the 200 files combined into 1 output. I hope it's possible. Thank you :) Unfortunately the files are over 100MB I'm unable to send samples. Here's the link though, https://accessgudid.nlm.nih.gov/release_files/download/gudid_full_release_20241001.zip Thank you again for any assistance

[cpet13 · Accepted solution]

Hi @rchua, I had a similar problem and found a solution in the batch macro. Check it out here - The Ultimate Input Data Flowchart. The last point is the one that talks about what you're looking for, I think. That link provides a download file for the macro.

[nagakavyasri · Accepted solution]

@rchua Use this setting in batch macro:

[rchua]

Thank you so much @cpet13 & @nagakavyasri I was able to make this work. I really appreciate it :D