Error: Input Data (1): Corrupt File: XML parse failure - cell has no column definition

Question

Hi All,

There is a weird thing going on with one of the data I am feeding in the Input tool of Alteryx which prompts:

"Error: Input Data (1): Corrupt File: XML parse failure - cell has no column definition"

Neither disabling the AMP Engine does not work at all nor the excel file is not corrupted and is very much usable. But still not sure what is leading to the issue.

Is there a way to bypass this? Any help would be very appreciated.
Thanks,

db89

Screenshot 2023-10-10 172616.jpg

db89 · Answer

Hey @apathetichell ,

Thanks, this was what I was actually doing manually. I thought there might be another way around this, but really appreciate for your response! :)

apathetichell · Answer

can you copy this sheet to a new excel file and save and then try? Alteryx is basically saying this excel file has issues.