Whitespace Issue Within Records of Certain Fields

Question

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?

UNWANTED_SPACES_IN_RECORD_ENTRIES.jpg

nick_furr · Answer

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

nagakavyasri · Answer

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 · Answer

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