Combining Multiple Excel Files Into One Excel File

[bennettam]

Hello! In Alteryx Designer version 2021.3.3.63061, I'm trying to combine 18 Excel files that have an identical layout and only one sheet per file "Sheet1". I'm getting an error saying there is no sheet with that name, specifically, "Sheet1 does not match a sheet or named range in...". Any suggestions?

[caltang · Accepted solution]

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

Use the batch macro and directory approach to call all data and then output accordingly.

[alexnajm]

@caltang ‘s suggestion should work to solve the use case, but I would also suggest looking to upgrade your Designer since your version is no longer officially supported!

[caltang]

Oh yea - @alexnajm is spot on. Please upgrade your Designer! Keep download copies as well ;)

[abacon]

@bennettam Shameless plug... here is a macro that does what you are looking for. There are lots of resources on the community that do this but have this link ready to go.

https://community.alteryx.com/t5/Community-Gallery/Dynamic-XLSX-Input-Tool/ta-p/1393832

Bacon