topic Re: Multiple excel files input on the Alteryx server in Alteryx Server Discussions

Multiple excel files input on the Alteryx server

olimpio — Tue, 15 Feb 2022 08:48:32 GMT

Can anyone share a workflow, that can be used on the alteryx server where the inputs is multiple excel files. the excel files should get consolidated into 1 data set then move forward into the workflow. The number of excel files are variable

any guidance is appreciated

Re: Multiple excel files input on the Alteryx server

atcodedog05 — Tue, 15 Feb 2022 09:07:27 GMT

Hi @olimpio

This article might be helpful for you

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Hope this helps : )

Re: Multiple excel files input on the Alteryx server

olimpio — Tue, 15 Feb 2022 10:28:56 GMT

Thanks Allot, one more question will this work once i move it to the server

Re: Multiple excel files input on the Alteryx server

atcodedog05 — Tue, 15 Feb 2022 10:30:42 GMT

Hi @olimpio

Provided your server is able to access the folder path it should be able to run.

Hope this helps : )

Re: Multiple excel files input on the Alteryx server

atcodedog05 — Tue, 15 Feb 2022 10:31:05 GMT

Happy to help : ) @olimpio

Cheers and have a nice day!

Re: Multiple excel files input on the Alteryx server

olimpio — Tue, 15 Feb 2022 14:32:07 GMT

hey thanks for your response, it works on the local drive but if you move it to the server, you can error invalid directory even though the server has access to the path, trying other options, but really appreciate your help on this thanks again