Woring with multiples XML files and extract data

[Erike]

Hi,

Hey I'm trying to run an workflow with the same logic:

1- one folder with N *.xml files with the same structure;

2- Read all files and extract 3 files with the info needed.

Its pretty simple  put in words, but I've tried so many times and with different ways with no success.

May someone please try to help me?

[Blake]

Hi Erike, 

Check out this post and workflow that @Aaron_Harter posted earlier this week. 

I think it will do what you're looking to accomplish. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-data-from-multiple-sheets-in-on...

[Aaron_Harter]

Thanks @Blake!

For this use case, the folder with XML files may be referenced with a Directory tool, then have the Batch Macro reference the full path field to process each XML independently and aggregate the transformed data:

[Erike]

Hi Aaron and Blake! 

Thank you for your answers and time, I tried to run, but certainly I've mistake in some step:

For some reason he said that was unable to unzipping the file, could you please help me to understand this?

[Erike · Accepted solution]

Hi guys,

I was able to create an batch macro slightly more simple, but it works smoothly!

Thank you for your time!!

[aragoncha]

Hello, Could you share your workflow?