Parse error

[yc151]

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.

[Qiu]

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

[yc151]

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?

[Qiu]

@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-pa...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/XML-Parse-Failure-cell-has-no-column-d...