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

Question

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?

OTrieger · Accepted Answer

@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.