How to be combined multiple excel sheets in Alteryx

Question

Hi Team,

I have received everyday 20 excel files so i need to combine all single file. And

output data load into SQL server database.

Attached sample files.

Please help me.

Regards,

Tgvr

B.xlsx

A.xlsx

ChrisTX · Answer

This is likely the most frequently asked question in this Community forum.

With so many Community messages, I know it can be hard to try to find a great answer using the Community Search.

Try starting here:

The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

And these posts may help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Load-multiple-Excel-files-from-specific-folders/td-p/470873

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Consolidating-100-Excel-Sheets-with-the-Exact-Same-Format-and/m-p/420738#M77874

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/CREW-Wildcard-Batch-Macro-Error/td-p/319509

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Importing-multiple-excel-files/td-p/344752

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-sheets-from-one-excel-file-with-slightly/m-p/420217#M77728

https://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-Simple-Batch-Macros/ba-p/2251

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Multiple-Excel-Files-Into-Multiple-Workflow-Dynamically/m-p/382513#M70056

https://www.concentra.co.uk/resources/articles/how-to-import-multiple-excel-sheets-and-files-with-different-schemas-in-alteryx/

Chris