community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Excel Importing Errors - New Characters

Meteoroid

I recently upgraded our designer and ran an import on an Excel file.  Now when I import it, it contains additional characters in the cells that weren't there before (thereby rendering our currently workflow useless).  It looks like it is assigning additional text (_x0032_) when there is a number error in the cell or "_x0020_" when there is a space in the cell.  Not sure why this is all of a sudden happening.  Nothing has changed in the native Excel.

Alteryx
Alteryx

Hi @apoeppelmeier,

 

did you see this post? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/When-using-Input-Data-spaces-in-the-he...

 

I believe the x0020 is the space characther in a hexadecimal format, not sure why it gets loaded this way. Try if the link above solves it.

 

Giuseppe

 

 

Labels