Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Have a gallery app which does not prompt for an excel sheet name

Bob_Blackey
11 - Bolide

Hi All,

 

I have an app that reads in two Excel xlsm files does some Alteryx magic and overwrites a sheet (Drop) in another.

 

The files are of a standard format so the two input files will have a sheet named "Data", and the output file I'm writing to has a sheet "ComboData".

 

My app prompts the user for the file name and I used:

 

 File Browse Tool :Arbitrary FIle Spec *.xlsm 

 

Action tool: Update Value  - for the  File value.

                   In replace a specific string I replace the entire file name (leaving the |'Data' )

 

This works fine when I run it locally - no prompt for a sheet name on input or output, but when published to the gallery it prompts for table/sheet name.

 

Is there a way to have it not prompt for a sheet name in the gallery?

 

Cheers,

Bob

12 REPLIES 12
delf
5 - Atom

Hello, any update regarding this issue?

Jo-B
8 - Asteroid

This is still an issue on the version 2021.2. 

 

I would appreciate here a fix of this! Thx.

npariso
10 - Fireball

Is this fixed yet? Seems like I am still having this issue.

Labels