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
Hey @Uzi,
What does it say here in your configuration? Are you specifying a range of cells?
Could you copy and paste the full error message from the results window?
Thanks,
Ira
Dear @IraWatt
no Im not specifing anything. Just pick the excel file (it doesnt matter drag and drop or by browsing) and there is only sheet1 as you can see
Can you show the error message @Uzi ?
I dont get the error because the path is correct and when im Changing the tab name to "Sheet1" then it works
@Uzi I would try just dragging the file onto the canvas. When I do it I get this for the table name:
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"
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |