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
Solved! Go to 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
This is not the item what I am looking out.