Whitespace Issue Within Records of Certain Fields

[nick_furr]

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?

[lbardoe]

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

[nick_furr]

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

[nick_furr]

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

[nagakavyasri]

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]

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