Is there an easy way to get rid of fields and modify field names from a summary statistic output table? e.g. when the tool runs it produces fields like OBJECTID (I don't need and I cannot use the delete tool), sum_DPT (I don't need sum at the beginning of the field name).
They have to be removed after (it may have references to it which won't be removed until the project is saved or the table is exported to a new one)
There is no way to modify the field names in place but they can be replicated and the old deleted, which is about as fast as the alter field names tool
Some more detail on the options Dan Patterson mentioned:
Alter Field—Help | ArcGIS for Desktop Alter Field Geoprocessing Tool
Delete Field—Help | ArcGIS for Desktop Delete Field Geoprocessing Tool
Chris Donohue, GISP
Thanks Dan and Chris, The alter field tool works great. It gives me the option to alter the field names. The customer doesn't want to see the object ID field. The delete tool cannot delete object id because it is the unique identifier. Is there a way to hide this field when the output table is created from the summary statistic tool (or do we have a geoprocessing tool that hide fields). I am consuming this table as a geoprocessing service in ArcGIS flex application. Since the output of the summary statistic tool is a table (recordset) and not a feature class (featurerecordset), it does not give me the option of a pop window that would allow me to hide fields or rename fields with aliases. The above responses were very helpful. Thanks a lot.
So the problem is that you want to keep it in the Arc*ish environment... hence it needs an ID field of some kind for sure. As soon as you start mentioning 'service', 'flex', 'web' I will have to defer to those that work in that realm to see if they have a suggestion ... perhaps rscheitlin or at least I would want to know from the client whether it is a need or a nice (usually it is the latter)
Simon,
You would have to edit the recordset and remove the unwanted fields in code before you use the recordset in your app. But honestly I have not used flex in two years or more (since it is a retired technology by esri now) so I am not sure how much help I can be.
Thanks Dan & Robert, It is just to make the table looks good and they also indicated that other users might know what OBJECT ID is. The geoprocessing widget in Flex produces the record set as its final product so there is no way I can modify it. I have been using AppBuilder in the past but my current organization uses flex builder because it is easier for them to host all the services in ArcGIS Server without requiring ArcGIS online or Portal for ArcGIS subscription. I also realized the output fields from the resulting table are arranged in alphabetical order which is not what I wanted like the example below. Any ideas?
Just an FYI, it looks like you AREA field is in square degrees... that may be more of an issue to explain than the id field name
Sorry, this is just an example I got from ESRI (ArcGIS Viewer for Flex). It shows the added ID field and how the fields are arranged alphabetically.