Alteryx Server - multiple excel files Input

Question

Hi is there a workaround for a scenario where there are multiple excel file as inputs. using "*.xlsx"  we are able to make the workflow function, however there seems to be a restriction on the server.

Note: the inputs are dynamic there could be 2 excel files or up to 12 on any given day.

is there any workaround for this, any suggestions would be of great help.

Peachyco · Answer

The Text Box Tool solution might work if the user gives the fully-qualified/absolute UNC path.

For example:

* The address on the user's machine might show like "G:\Folder Location A\Folder Location B". This won't work on the Gallery 'coz the Gallery is working from its own machine and the drive might not be mapped in the same way there.
* To get it to work, the user must change the address to be like "\192.168.00.00\Folder Location A\Folder Location B". This form leaves no ambiguity and Alteryx will find that address from any machine.

The issue would be whether or not your users are computer-savvy enough to provide the proper address. Some workarounds I can think of:

* Before passing to the Input Tool / Dynamic Input Tool, use a Formula Tool or something similar to modify the address into the required form.
* If the folder locations are already known anyway, use the Drop Down Tool instead of the Text Box Tool.

JC · Answer

hi, we meet the same issue, do you find a way to resolve it?

olimpio · Answer

would you be able to share a workflow that would help? that would be really helpfull