Combining many excel workbook (over 100)

[Jwwwson]

Hi, 

Please advise if there is any way to combine many excel files, say over 100, by using Alteryx workflow, without placing over 100 data input tools and insert one by one,  into one data pack?

Thanks & regards,

Jason

[RolandSchubert]

Hi @Jwwwson ,

if you want to load the same sheet from all files and the files are in one directory, an input tool would be sufficient. Just use "*.xlsx" instead of the file name.

Let me know if it works for you.

Best,

Roland

[Jwwwson]

Hi @RolandSchubert 

Thanks so much for your prompt reply!

I am not sure if I understand. So I shall use one Data Input Tool or one Directory Tool to load all the excel files? And where shall I use ".xlsx." ? 

Cheers, 

Jason

[RolandSchubert · Accepted solution]

I assumed, all files are in one directory:

The Input Data tool should be configured like that:

I hope this explains it a little better.

Best,

Roland

[Jwwwson]

Hi @RolandSchubert , 

It works! Thanks so much for your elaboration and advice!

Regards, 
Jason