No sheet Specified, You must Specify a Sheet

Hi guys,

I'm trying to download this excel file off the internet, but it seems like I cant use the Dynamic input for some reason. I've tried the solutions that I found on some other topic but its not working. Can someone please help me out!

Thank you 🙂

downloading.yxmd

Error Message

Accepted answers

JoshuaGostick

Hi linwk,

I think the issue you're having is that the size of the Filename field is too small and therefore missing the |||<List of sheet names> part. Just add a Select tool before the Formula tool and increase the size of Filename so that you're getting the correct value going into the the Dynamic Input tool.

Let me know if this works.

Thanks,

Josh

SamDesk

Hi @linwk,

You need to change your Dynamic Input Tool to "Change Entire File Path"

Sam 🙂

All comments

JoshuaGostick

Hi linwk,

Let me know if this works.

Thanks,

Josh

SamDesk

Hi @linwk,

Your Filename column is being truncated when you try to add the sheet name to it:

This happens when it reads the column in from the Text Input tool; Alteyrx auto-determines what it thinks will be the best field size for the column. To remedy this, just add a select tool and change the size to a more appropriate one:

Additionally, you need to amend your formula to the following string:

[Filename] + "|||<List of Sheet Names>"

Alteryx won't recognise "List of Sheet Names" unless "Sheet" and "Names" are in proper case.

Sam 🙂

downloading2.yxmd

linwk

Hi Joshua,

It works fine now. Thank you very much. Another question though, if i'm trying to get say <Table 2> in the excel file, does the same method apply? I tried doing it but now it says it does not match a sheet or named range is corrupt

linwk

Hi SamDesk,

I tried to get one of the Tabs Named Table 2 using the same method, but it doesnt seem to work, what could be the issue here? I have attached the new workflow!

downloading.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703