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

Question

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!

test_macro.yxwz

test_sheetname.yxwz

Test01.xlsx

RolandSchubert · Accepted Answer

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