Input multiple excel files from the same directory

[ejin]

Hi all, 

I am trying to figure out if there is a way to input all the excel files in a folder at once? For example, the following 8 files are in the same folder, is there a way to input them at once instead of create 8 input icons? 

Thank you in advance for your help!

[fmvizcaino · Accepted solution]

Hi @ejin ,

Yes, it is possible! In the attached example, I'm showing how to do it with a directory tool and a dynamic input tool. 

The only thing to keep in mind is that you need to have the same file structure for all of them.

Best,

Fernando Vizcaino

[ejin]

Thanks @fmvizcaino ! The workflow works perfectly! Just out of curiosity, seems like all the excels are combined into one data set now, is there a way separate them into different excel files as output (similar to how you input them dynamically?

[Loic]

@ejin if the files have the same structure and only one sheet (with same name). you can simply add one "Input Data" tool and edit the path to:

Use * to replace any set of characters.

"C:\Path\Alteryx_Input*.xlsx" 

Alteryx will automatically stack the files on top of each others.

Note you can use ? for only one character.