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.
@yc151
Can you try the remove Punctuation option in Cleansing Tool?
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?