lygismav

Export table using field alias as name, remove join table name from field name

Discussion created by lygismav on Apr 25, 2011
Latest reply on Aug 22, 2018 by alexfriant
Hello,

I am joining a table to a layer in Model Builder, then exporting the layer to a new feature class.  When I join, then export the data all of my fields are renamed to SourceTableName.FieldName.  I would rather that the fields in the exported feature class not include the name of the source table.

Here is an example of the current fields:

TaxData.PIN
OwnerData.Owner

Desired:

PIN
Owner


*************************
Solutions:

1) Go through "add field, and calculate field" for each of my fields (about 30 in total).  This solution is very unfriendly

**************************

How can I instead:

1) rename fields in the geodatabase via model builder?
2) have ArcMap / ArcCatalog not rename fields to table.field when joining data?
3) when exporting the feature class use the alias as the names of the field on the export?

Outcomes