"Name" Field Truncating when running Transform Map

[Charles Hong]

Hello - 

I have a Transform map that is running a transform on a sepcific table from an import set. When running the transform and within that table there is a "Name" field, when i run the transform some of the records on that "name" field are truncating at no more than like 250 characters when there are other records under the "name" field  that exceeds over that 250 character limit. 

Would anybody happen to know why or what is going on?

[Tony Cattoi · Accepted solution]

Have you taken a look at your import set table and verified that the "name" field there isn't being truncated when the data is being imported.  I've had that happen a few times where I had to increase the size of a field on an import set table to ensure all data was being imported.

[ericcrawford]

Thank you, Tony!  Solved a puzzle for me.

[ARG645]

Please check the field max length in the import set and re-adjust the max length if needed. 

[Charles Hong]

Hey Guys quick question - it seems like i am at my import set table (same table as defined on the transfrom map as Source Table).  But here, how would i check to see if the "Name" Field has a character limit or how would i even be able to expand it?