5

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.

4 Answers 4

13

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.

4

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.
3
  • I'm finding that the alias values are ignored, and instead the field name is used. Have you had better luck? I'm using 10.2 Commented Mar 3, 2016 at 11:12
  • 1
    also in 10.4 , Using fields allias as column header in "Table to Excel" does not works.
    – Ali
    Commented Feb 7, 2017 at 14:55
  • also in 10.6, "Table to Excel" with alias checked but it's ignored...
    – Dawn
    Commented Jul 7, 2018 at 20:43
1

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.

0

There is 65535 record limit for the table to XLS tool. We need the option to use aliases in a csv export.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.