Alteryx Designer Desktop Discussions

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

Loop workflow for multiple xml files

panupeltola
5 - Atom

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!

 

11 REPLIES 11
JoeS
Alteryx
Alteryx

@FabioP wrote:

Could you guys help me?

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

 

 

FabioP_0-1666876004366.png

 


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

NeilFisk
9 - Comet

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?

Labels