Woring with multiples XML files and extract data

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?

XML READER.yxmd

Parse

Accepted answers

Hi guys,

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

Thank you for your time!!

All comments

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-one-file-and-put-in-a-single/m-p/526832/highlight/true#M111517

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:

Quick Links

Tags

This months top contributors

Hollingsworth 335