Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Input tool shows excel sheets / tabs that don't exist

jmer
5 - Atom
 

See screenshot of weird "DS_INTERNAL...." sheets that don't actually exist when I open the excel file. My issue is the file name changes often so I have the input tool set to "*.xlsx", and normally I dont need to specify the sheet name because its only one sheet. But now, I'm getting errors requiring me to select "sheet1", even though it is the only sheet. Anyone know what is happening and how I can prevent this?

 

Screenshot 2024-11-02 135259.png

2 REPLIES 2
apathetichell
19 - Altair

That toggle displays both sheets and named ranges/tables. Either they are hidden tabs or named ranges/excel tables.

OTrieger
12 - Quasar

@jmer 

If you have it in the user interface it is means that it coming from the excel file. Alteryx does not add sheets that are not there. So they are hidden, If you know that you need always Sheet1, you can automate it in the following way, get the guys to select the option List of Sheet Names. In your WF replace ,List of Sheet Names> with File Name and then Get the unneeded sheets filter out and you can open the file now.

Labels