Multiple excel files input on the Alteryx server

[olimpio]

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

[atcodedog05 · Accepted solution]

Hi @olimpio 

This article might be helpful for you

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

Hope this helps : )

[olimpio]

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

[atcodedog05]

Hi @olimpio 

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

Hope this helps : )

[atcodedog05]

Happy to help : ) @olimpio 

Cheers and have a nice day!

[olimpio]

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