Free Trial

Alteryx Designer Desktop Discussions

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

[Urgent] Analytic App - Input error: No sheet specified, you must specify a sheet

hungdm
8 - Asteroid

I'm trying to build an app, there are 2 issues now:

 

1. The app will contains multiple radio buttons: Each button is to enable a single corresponding container in the workflow if it is selected.

=> I disable all containers and create a Condition tool to enable one of which by an Action tool.

Will it work?

 

2. One of my input file has multiple sheet. I tried 2 different version to input all of the sheet to cover 2 cases: all sheets have the same or different schema. The first workflow will use dynamic input whereas the second one will employ a macro.

 

However, there has been always an Error log for 2 versions when I run the app independently:

"No sheet specified, you must specify a sheet".

 

If I run the workflow in alteryx, it will work normally.

How can I fix that issue?

 

Many thanks!

2 REPLIES 2
hungdm
8 - Asteroid

Could anyone give me an idea?

Thanks!!!

RolandSchubert
16 - Nebula
16 - Nebula

Hi @hungdm ,

 

I think, the problem has been caused by the Action tool, tat you used to update the filename. You selected "Update Input Data Tool" thereby overwriting both the filename and the table or query (List of Sheet Names) leading to the error message. I've changed the settings within the Action tool to "Update Value" and selected the filename only as a string.

 

Let me know if it works for you.

 

Best,

 

Roland

Labels
Top Solution Authors