Is there a way I can modify the Field Name or to make him keep the Alias when a table is exported?
Or is there a way to keep the Alias instead of the Field Name, when exporting for example to .dbf ?
I want to be able to do this in ArcMap.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
If you use the ArcToolbox Tool "Table to Table" you can add, rename, or delete output fields using the Field Map Parameter. With arcpy you can use the tool and build your own field map. That field map can use the aliasName property of the field object (have a look at the FieldMappings example 2.
With ArcGIS 10.1 you are able to rename the field name in ArcCatalog (table properties), if your data source is a FileGeodatabase.
The most reliable way to do this in ArcMap is to use the Table to Excel (Conversion) tool, making sure the Use field alias as column header checkbox is checked:
How column names in the output are determined.
- NAME —Column headers will be set using the input's field names. This is the default.
- ALIAS —Column headers will be set using the input's field aliases.
I finally got this to work in 10.6, the key was to save the alias field in ArcCatalog (not ArcMap).
Which is what I think the poorly written note means to say: Column headers will be set using the input geodatabase table's field aliases. If the input is a layer in a map, the value set on the layer's field alias is ignored.