topic Gallery - Input File - <List of Sheet Names> in Alteryx Server Discussions

Gallery - Input File -

wolfgangh — Mon, 06 Apr 2020 23:56:22 GMT

Hi all,

we created a workflow, that runs on the local machine. As soon as we run it on the server, we have a couple of different issues, that will disturb the user.

1. The input tool offers to choose the <List of Sheet Names>. It would be helpful to suppress the this selection

2. The Gallery gives feedback, that the result did not create results. That is not true, since the workflow creates files that are store on a share drive. Is there a way to adapt that? If I run the workflow on the local machine, I can at least see the file that was created.

Thanks for your help!

Best regards,

Re: Gallery - Input File -

fmvizcaino — Tue, 07 Apr 2020 02:01:06 GMT

Hi @wolfgangh ,

For your 1st question, I don't think it is possible to remove the option to list sheet names.

For the 2nd one, I suggest you to insert a browse tool in paralel with your output data tool and to configure the interface designer as follows:

When checking the browse tool, your workflow will produce a view of your file in your gallery results.

Best,

Fernando Vizcaino

Re: Gallery - Input File -

DavidP — Tue, 07 Apr 2020 07:01:30 GMT

For Question 1, perhaps you can try changing the file format (Option 2) to Microsoft Excel legacy (xlsx) - this does not support list of sheet names. I have not tested how this looks on Server though.