ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Input Data (5): No Sheet Specified, you must specify a sheet error

dmccombie
Meteoro

I am looking for some help on an issue using the File Browse with and Action and Input Data tools and getting an error message.  I used an old post to make sure that I have it configured correctly. Solved: File Browse - No sheet specified - Alteryx Community  I have tried the same things as in this post but getting a Input Data (5): No Sheet Specified, you must specify a sheet error.  I am unable to provide an example of my workflow since it is on a client computer.  Can anybody help solve this for me?  I may be able to mock up a dummy workflow on my end if needed to show and example of what is happening.

19 RESPUESTAS 19
alexnajm
19 - Altair
19 - Altair

Have you Debugged your app in the Interface Designer to make sure the File Browse is updating the Input Data correctly? In most cases, it will be your Action tool!

alexnajm
19 - Altair
19 - Altair

Show us a screenshot of your debug if you can

dmccombie
Meteoro

I did and it doesn't look like the file is being updated in the Input Data when I run it.  In Action I have 'Update Value' then the File - Value with the Path of the file for the Input Data template, then I have Replace a specific string checked with the path and file name of the template.  

dmccombie
Meteoro

Here are the screenshots of an example of the workflow and the debug

Screenshot 2025-02-13 173609.pngScreenshot 2025-02-13 173639.pngScreenshot 2025-02-13 173658.pngScreenshot 2025-02-13 173713.png

dmccombie
Meteoro

@alexnajm I just posted up my screenshots

alexnajm
19 - Altair
19 - Altair

Can you just do "Update Input Data Tool" as your action?

dmccombie
Meteoro

@alexnajm still same error.

alexnajm
19 - Altair
19 - Altair

It’s all working fine for me, so it’s hard to shoot in the dark without seeing what you are doing. Are you selecting a different file format than xlsx?

dmccombie
Meteoro

@alexnajm can you send me an example workflow of what you ran?

Etiquetas
Autores con mayor cantidad de soluciones