Loop workflow for multiple xml files

Dear Alteryx Community,

I have a requirement to parse and combine approx. 250 xml files. For this purpose I am using XML input/parse tool that is downloaded from Alteryx Gallery (link below). Rest of the workflow uses basic tools like select, formula, text2columns etc. (see picture attached)

Link to XML parse tool that im using:

https://gallery.alteryx.com/#!app/XML-Parse/5c1ef7bb0462d70ba8a4b755

All xml files have the same structure (identical column names) and they are located in the same folder.

Question is:

Instead of manually copy-pasting workflows for 250 files, is there a way to loop transformation workflow (transform data from xml to spreadsheet format) for all files?

Thank you for your reply in advance!

XML loop.png

Parse

Macros

Accepted answers

JoeS

Hi @panupeltola

No problem at all.

Please find attached the example workflow with the batch macro too.

ExamplewithBatch.yxzp

All comments

JoeS

Hi @panupeltola

You'll want to create a batch macro to loop through each file.

If you upload a few sample XML files and your workflow. I'll be able to convert it or feel free to look at some of the great articles on here around batch macros.

panupeltola

Hi JoeS,

Please find attached example workflow and example xml's. Let me know if you need any more details. Thank you so much!

example.xml

Example workflow.yxmd

example -3.xml

example - 2.xml

NeilFisk

If the structure of all the XML files is the same, you can put them all in one folder and use a wildcard on the input tool that selects *.XML. The challenge is the fields need to be identical in each file or they will be skipped when using the input in this fashion.

davidhenington

@DiganP Hi there i'm interested in reviewing the XML tool that is referenced in this thread, but it appears unavailable from the download site that's listed. Can you assist?

Best -

David

FabioP

Could you guys help me?

What should I do here? I don't have this Engine.py (Python File).

JoeS

@FabioP wrote:
Could you guys help me?
What should I do here? I don't have this Engine.py (Python File).

Hi @FabioP - I think I have attached it now.

LoopXML.yxmc

NeilFisk

I didn't use Python to loop through over 10,000 XML files to parse them out (and they were not all the same). If you create your first workflow to parse one XML file the way you want it, you can then convert that to a batch macro and use the directory tool to loop through it. Is that what you're looking to do?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703