Using a wildcard for XML input with different fields

I have thousands of XML files that have similar fields, but not all fields are used in all files. I wanted to input these using a wildcard, but when I do, Alteryx will use the structure of the first file to open the remaining files, and ultimately skip files that don’t have the same fields. How does one get around this limitation.

Any suggestions would be welcomed.

Input

Accepted answers

AbhilashR

Hi @NeilFisk, I have created a mock solution (attached) to help you get started. In this I use the:

Directory tool - to bring us a list of XML files in the folder (point it to your folder which has the xml files)

Select tool - to only use FilePath field

Custom Macro - right click and hit Open Macro option on this tool to look at how it was built

In my example I passed two xml files to the macro and the output shows it brought in data from two xml files into Alteryx. I hope this helps!

sampleXMLReader.yxzp

NeilFisk

Abhilash,

This worked flawlessly. Thank you so much for your guidance.

Regards,
Neil

All comments

AbhilashR

Hi @NeilFisk, how about doing an xml read within a standard macro to which you pass the location of each file from upstream? This way the macro treats each file as unique and unions the data before it gives one output.

NeilFisk

I'm not that familiar with setting up macros. With close to 10,000 files, I don't want to be identifying each file name somewhere because that would take a rather long time to do and I could potentially miss a file. Is there a way to read the names of the files in a folder and then set up the macro you are talking about?

Thanks for the help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703