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

[dmccombie]

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.

[alexnajm]

I can, but you can also just check out the File Browse example in designer

[alexnajm]

Works fine for me

[dmccombie]

@alexnajm  if you can, the example doesn't have something specific that addresses an excel spreadsheet with multiple sheets on it

[alexnajm]

Well that's a big difference that wasn't known before! Please provide this in the description next time :)

What is your end goal then?

[dmccombie]

so i need to browse for a file with multiple sheets in it using the interface tool then bring in the 'complaints' sheet (in this example) to the input data tool then perform some filters on the file then eventually output the sheet that I brought in.

[alexnajm · Accepted solution]

Actually then wait a second, my example DOES work then with reading in one sheet from an excel with multiple sheets. I don't understand the error you are running into or what you want that's different than the example I provided - you can select the file with the complaints sheet and it works.

Use my example, and tell me what's broken - otherwise please describe further what you need because I must be missing something. Ideally I would like your workflow since it's difficult to help further from here since my solution works based on your description

[dmccombie]

@alexnajm Thank you for your help with this.  For the File Browse section, I had it as Arbitrary File Selection, so when I selected the file, it did not prompt me for a Sheet to select.  When the Standard Database File format is selected, it prompts to select the Sheet that you want from the file.  This will work for now, but is there a way that would not need the user to specify the sheet to select from?  

[alexnajm]

Yes it's possible, but I personally don't think it's a good idea based on the trouble that it was causing. You would have the Action tool Update via Formula and strip off the sheet name at the end to replace it with "complaints" so it grabs that sheet no matter what

But from a user experience, just ask them in the instructions to select the correct sheet (likely named "complaints" but in theory it could be any name)

[dmccombie]

@alexnajm makes sense.  thanks for all the help.  sorry about the confusion....

[alexnajm]

It’s ok - just make sure to mark one of my responses as a solution!