topic Re: Combining many excel workbook (over 100) in Alteryx Designer Desktop Discussions

Combining many excel workbook (over 100)

Jwwwson — Mon, 20 Apr 2020 09:29:54 GMT

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

Re: Combining many excel workbook (over 100)

RolandSchubert — Mon, 20 Apr 2020 09:34:57 GMT

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

Re: Combining many excel workbook (over 100)

Jwwwson — Mon, 20 Apr 2020 10:22:22 GMT

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

Re: Combining many excel workbook (over 100)

RolandSchubert — Mon, 20 Apr 2020 10:23:43 GMT

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

Re: Combining many excel workbook (over 100)

Jwwwson — Mon, 20 Apr 2020 10:43:40 GMT

Hi @RolandSchubert ,

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

Regards,
Jason