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

Question

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

HomesickSurfer · Answer

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.

jeffwongarrow · Answer

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 · Answer

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!