How to open each sheet, run through the workflow and then merge them together at the end

Question

Hi! I'm new alteryx user and have one issue that I have to solve quickly:
I have one excel file with multiple sheets, each sheet should run through the workflow that I created that looks like this:

and then at the end all sheets should be combined (one below the other). I saw that this should be done with Batch Macro, but I tried it and somehow didn't manage to make it properly. Should I make Batch Macro that will open each file and then connect it to this workflow or how should I do it?
Thank you!

m_shur · Answer

Can you pls share how you achieved it?

Duki · Answer

Thanks, I managed! 🙂

messi007 · Answer

@Duki,

You can take a look on those posts as well :

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

Hope this helps!

Regards,