Parse error

Question

hi, community,

I am downloading the data/excel from a software (see attached pic) and every cell is in = "  " format. I can't use this input as Alteryx give an error unless I hardcode first. Is there a way I can do it without performing the manual step of hardcoding? Thank you for your help.

Capture.PNG

Qiu · Answer

@yc151 Based on the discussion below

it might be

1. Corrupted file

2. Incorrect delimiter setting

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Input-Data-1-Corrupt-File-XML-parse-failure-cell-has-no/td-p/709585

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/XML-Parse-Failure-cell-has-no-column-definition/td-p/892099/page/2

yc151 · Answer

hi! the issue is this error happened at input data tool, the error message says" corrupt file, xml parse error excel with no column definition", i attached the pic below. so i can't use any data cleansing tool since the input data step has to be configured properly first. what should i do?

Capture.PNG

Qiu · Answer

@yc151 
Can you try the remove Punctuation option in Cleansing Tool?