Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here

Gallery - Input File - <List of Sheet Names>

Highlighted
8 - Asteroid

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,

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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:

fmvizcaino_0-1586224802487.png

 

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

 

Best,

Fernando Vizcaino

 

 

Highlighted
16 - Nebula

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.