Consolidate excel sheets

[b_urhan]

Hello Alteryx Community,

I have one excel file and 337 sheets in it. Is there anyway to combine all sheets in one output like union tool does.

Thanks for your answers already

[AngelosPachis]

Hi @b_urhan ,

This is a common question in the community and if you look around I'm sure you will find a post that talks you through how to do what you are after. As an example, there is the following post that you can follow:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-multiple-excels-into-one-wor...

Hope that helps,

Angelos

[mceleavey]

hi @b_urhan ,

I've attached a couple of tools and an example which will allow you to do exactly this.

The first tool loads in all sheet names from the excel sheet(s), then combines them with the filename. This then dynamically loads in all sheets from all selected workflows.

I hope this helps.

M.