Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic XML input

Genevieve
8 - Asteroid

Apologies if this already answered.

 

I am trying to read a bunch of XML files (400+). They are all saved in the same directory. However the dynamic input tool does not work as there are variations in schemas between the files. I have used a batch macro found on the Community. It seems to only grab the top file in the directory.

After inputing all the files I need to parse the outer XML to access the data needed.

I think the problem is in the macro. Could you help me find where I got it wrong?

 

 

2 REPLIES 2
MichalM
Alteryx
Alteryx

@Genevieve 

 

I'd update the macro to read the xml in as a csv with no delimiter (see below) and then use the XML Parse tool to get what you need out of the outer XML. The way the batch macro works will replicate the same process for each of your XMLs and then union the output on the back of it.

 

 xml-batch.png

Genevieve
8 - Asteroid

Thank you @MichalM .

 

Your suggestion of CSV put me on the path to the solution.

Labels