Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Merge multiple input excel files from a specific folder in Alteryx

ashissanpui
9 - Comet

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 

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

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
9 - Comet

This is not the item what I am looking out.

Labels
Top Solution Authors