Merge multiple input excel files from a specific folder in Alteryx

ashissanpui

Hi, 

I am having 50 excel data files whose input formats are same and I want to merge them into one file. I want to specify a path from where Alteryx can get the files and merge them into one file. Do let me know the solution, please.

Thank You,

Ashis 

BenMoss

Relatively straight forward providing the schema is exactly the same.

If all of your sheet names across the 50 different files are the same then you can simply use a wildcard to replace the file name within the input tool.

If not, check out the 'Wildcard xlsx' input from the crew macro pack: https://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2015-Q3-Release/ba-p/5423

Ben