Input multiple files and format before unioning

[m_hohaus]

Hi community, 

I am currently trying to develop the following workflow:

1. Imports all excel files from a given folder
2. Formats *each* file before unioning them
3. Then performs some other actions on these files

I have tried using a wildcard and have had a go at batch macros, but I haven't quite succeeded - could you give me a hand here?

Thank you very much for your help!

Maria

[markcurry · Accepted solution]

Batch macros do seem the way to go, here's a link to the Knowledge Base article on Batch Macros...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

[m_hohaus]

Thank you! I persisted and it worked 🙂