how to merge multipile excel file into 1 workbook with different tabs

[jeffwongarrow]

Dear All

I am a new user of Alteryx with very limit knowledge about it and hoping everyone can help me for this task

I have a daily work to combine 10 excel files into one workbook with multiple tabs, for example:

files A B C D E F G H I J K,  I need to combine these files into 1 file and rename the tab, 

so the output file should be 1 file with tab 1 2 3 4 5 6 7 8 9 10, and I don't need to do any data cleaning or filtering stuff, just to combine and renew it. Wondering if anyone could help

Thanks All

Best Regards

Jeff  

[Qiu]

@jeffwongarrow 
Maybe this is what you want and please adjust the file path.
I borrowed the Macros from this forum though.

[HomesickSurfer]

Hi @jeffwongarrow 

If your source workbooks each have a single worksheet, each named the same (eg. Sheet1), and; same columns/fields, you can achieve desired results quick and easy using just 5 basic tools as follows, or modify to suit.  Hope this works for you!

[jeffwongarrow]

Thanks all

I just found out the most dumb way, I just set 10 input path and 10 output path, as long as these output paths are save in same location with same name, they will automatically combines into different tabs and I can change the tab name when I setting the output files.

[HomesickSurfer]

Hi @jeffwongarrow 

Consider the suggested alternate approaches if your source data does not remain at 10 inputs, and; you will require use of multiple 'Block Until Done' tools throughout in order to write to the same output.  That's a lot of tools on your canvas, possibly affecting your overall runtime as well.