Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Combining multiple Excel workbooks into a single Excel workbook

MR
5 - Atom

I have numerous Excel workbooks in a single folder that I want to combine into a single Excel workbook.  Each workbook only has 1 worksheet.  Each tab, or worksheet, has a unique name (this seems to be source of my confusion).  The schema is identical across all of the Excel workbooks.  How do I combine these into a single Excel workbook?

 

Thanks!!

 

MR

1 REPLY 1
Drussek
9 - Comet

Hi @MR take a look at attached workflow.

It creates one output file with Sheets from every xlsx file in a choosen folder.

 

Labels