Input tool shows excel sheets / tabs that don't exist
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That toggle displays both sheets and named ranges/tables. Either they are hidden tabs or named ranges/excel tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
