Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here
SOLVED

"no sheet specified" error when a sheet has been specified (Dynamic Input)

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Can you try:

File name.xlsx|||Sheet1

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
6 - Meteoroid
HI
For some reason that didn't work out either. However I tried to delete the Dynamic Input tool and read it again and that for some reason seemed to fix the issue.


Vijayasaharan Rajagopalan
NBCUniversal
Technical Lead, Global Media Operations
Office: 1-818-777-1423 | Cell: 1-747-203-2508
Email: vijayasaharan.rajagopalan@nbcuni.com
Highlighted
5 - Atom

I added  formula tool between the directory tool and the dynamic input witch concatenated the sheet name FullPath = [FullPath]+'|||sheetName'

 

Capture.PNG

Highlighted
5 - Atom

The same issue for me - even after following the thread.

Please help

 

Regards

Bhushan

Highlighted
8 - Asteroid

Hi,

 

Just wondered if you ever got a fix for this? I have exactly the same issue, I have tried all of the suggested fixes and still get the error "No sheet specified". Really frustrating as if I remove all the other sheets in the work book so the one I need is the only one there, it works no problem?

Highlighted
5 - Atom

This worked for me; however, it slowed the process down.  Added about 20% more to the run time.

 

Labels