Free Trial

Alteryx Designer Desktop Discussions

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

Whitespace Issue Within Records of Certain Fields

nick_furr
5 - Atom

Hello!  I'm currently creating a table and I'm having trouble deciphering why certain Fields populate Records with whitespace between each individual character upon load-in. I've double checked the integrity of all data on my initial input.   I've tried Data Cleansing (All 3 whitespace options), Changing Data Types, Using a .CSV file as my initial input.  I've attached a snapshot of what it looks like.  Has anyone else ever experienced this or provide any insight?

 

 

5 REPLIES 5
lbardoe
8 - Asteroid

Is this potentially and encoding issue is the data encoded as UTF-8.

nick_furr
5 - Atom

It wasn't but tried as that encoding to no avail.

nick_furr
5 - Atom

Good afternoon, this problem still persists. Any advice on where to find potential insight?

nagakavyasri
12 - Quasar

As you are using a csv file as input, all the data would be loaded as strings. Insert 'Auto-field' tool after Input data tool to change the datatypes and then check if the whitespace still exists.

nick_furr
5 - Atom

I've tried the Auto-Field function but it won't write to the database due to the following error message:

"DataWrap2ODBC::SendBatch: String is too long and would be truncated"

I grabbed a select tool and even tried maxing out all string fields with V_W String (255) and it failed as well

Labels
Top Solution Authors