- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2019 11:07 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2019 11:10 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2019 12:38 PM
Right Click on Column headers from the list view
Configure -> Table
This will land you on the table configuration page where you can see all the columns.
If you don't happen to find the max length column there, then click the COG icon and get it on to the surface.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2019 12:54 PM
If you're already on the table, and see the field you want, right-click on the name of it, and configure dictionary. Change the max length to a more appropriate number.
