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 · Accepted solution]

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

[ashissanpui]

This is not the item what I am looking out.