Input data does not match sheet

Question

Dears,

I got an issue with the Input Data tool.

I got an Excel with only one tab called "Export". I'm trying via the Input Data tool to import it to my Alteryx workflow but it keeps always bring me the error message "Error: Input Data (138): 'Export' does not match a sheet or named range in ................ or the Excel file is corrupt."

I can solve the error when I change the tab name in Excel to Sheet1 but this is not what I want.

Does anyone know how to change the Query from "Sheet1" to "Export"?

thanks in advance

Uzi · Answer

That's exact what I tried. Even in a new location with a new workstream, same error. It cant find the sheet "Export" and all the time referring to "sheet1"

IraWatt · Answer

@Uzi I would try just dragging the file onto the canvas. When I do it I get this for the table name:

Uzi · Answer

I dont get the error because the path is correct and when im Changing the tab name to "Sheet1" then it works