Alteryx Designer Desktop Discussions

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

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

dmccombie
7 - Meteor

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 REPLIES 19
alexnajm
18 - Pollux
18 - Pollux

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
18 - Pollux
18 - Pollux

Show us a screenshot of your debug if you can

dmccombie
7 - Meteor

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
7 - Meteor

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
7 - Meteor

@alexnajm I just posted up my screenshots

alexnajm
18 - Pollux
18 - Pollux

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

dmccombie
7 - Meteor

@alexnajm still same error.

alexnajm
18 - Pollux
18 - Pollux

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
7 - Meteor

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

Labels
Top Solution Authors