Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Input data does not match sheet

Uzi
8 - Asteroid

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

6 REPLIES 6
IraWatt
17 - Castor
17 - Castor

Hey @Uzi,

What does it say here in your configuration? Are you specifying a range of cells?

IraWatt_0-1655379664110.png

Could you copy and paste the full error message from the results window?

Thanks,

Ira

Uzi
8 - Asteroid

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

Uzi_1-1655380879604.png

 

IraWatt
17 - Castor
17 - Castor

Can you show the error message @Uzi ?

Uzi
8 - Asteroid

Uzi_0-1656078623140.png

Uzi_1-1656078647888.png

 

Uzi_2-1656078680725.png

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

IraWatt
17 - Castor
17 - Castor

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

IraWatt_0-1656082559594.png

 

Uzi
8 - Asteroid

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"

Uzi_0-1656082726651.png

Uzi_1-1656082758573.png

 

Labels
Top Solution Authors