Input multiple excel files from the same directory

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!

Workflow

Accepted answers

fmvizcaino

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

Ex3.zip

All comments

fmvizcaino

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

Ex3.zip

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703