topic Re: Open multiple excel files as input in Alteryx Server in Alteryx Server Discussions

Open multiple excel files as input in Alteryx Server

db89 — Tue, 14 May 2024 07:25:52 GMT

Hi All,

I am trying to load multiple excel files as inputs in Alteryx Server, knowing the fact that directory tool+dynamic inputs might not work. Is there any other way to it like similar to using wildcards in desktop application?

If there is a solution, can someone please guide on this how to build it?

Thanks,

db89

Re: Open multiple excel files as input in Alteryx Server

cpet13 — Tue, 14 May 2024 16:01:55 GMT

@db89 if all of the excel files are named similarly (just a different ending) and are in the same location, you can use a simple input data tool with a * wildcard. When you setup the connection, just replace the end of the string. Example:
Folder\File_Name_*

Re: Open multiple excel files as input in Alteryx Server

db89 — Wed, 15 May 2024 14:28:30 GMT

@cpet13 thanks for your response. so do you mean that in server it would allow me to put the wild card to load all files from that folder?

Re: Open multiple excel files as input in Alteryx Server

cpet13 — Fri, 17 May 2024 14:17:22 GMT

@db89 if the server has access to that folder, it should do that, if you put the wildcard in the workflow's input data connection.

Re: Open multiple excel files as input in Alteryx Server

db89 — Wed, 22 May 2024 09:17:53 GMT

@cpet13 yes server has access to the folder, I can use the wildcard but strangely it does not allow me to edit the input filed in the server to use the wildcard.