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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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