Hi I am realizing that for some reason my string fields are over a million characters long and when it gets published to my web map it makes the map run extremely slow. I have a tool set up that allows you to input a new csv file and go from CSV-> ArcSDE feature class so that way the web map can get automatically updated. In doing so I would like to add the alter field tool in my model builder so that I can trim the string fields down to an appropriate length before it gets added to ArcSDE.
The alter field tool won't let me change the field length unless the table is empty. I have a part in my model builder where the attribute table is deleted and then appended with the updated information. I want to add alter field after delete and before append. When I do this it won't let me choose a field length because its not recognizing in this step that the feature class is empty. Does anyone know how to get this to work? See attached image of my model builder.
Thanks,
Melissa