topic Re: Getting field name and alias list from data set? in Python Questions

Getting field name and alias list from data set?

GareySmiley — Wed, 14 Sep 2016 20:28:38 GMT

Is there a script that will dump the field names along with the field alias. I'm looking to get something like the following dumped for a data set.

Field, Alias

TOTPOP_CY, 2015 Total Population

HHPOP_CY, 2015 Population in Households

Re: Getting field name and alias list from data set?

BrittneyWhite1 — Wed, 14 Sep 2016 20:35:22 GMT

You would use the arcpy Describe function. You can then access the fields property which returns a list of Field objects that you can iterate through to get the aliasName and baseName properties.

Re: Getting field name and alias list from data set?

BrittneyWhite1 — Wed, 14 Sep 2016 20:37:12 GMT

You can also use ListFields to access the fields.

Re: Getting field name and alias list from data set?

FreddieGibson — Fri, 10 Dec 2021 23:39:27 GMT

# This is essentially the line you'll need
[(f.name, f.aliasName) for f in arcpy.Describe(<PathToTable>).fields]

# This is an example of a way to use it
import arcpy
print("Name,Alias")
for item in [(f.name, f.aliasName) for f in arcpy.Describe(<PathToTable>).fields]:
    print(",".join(item))

"""
The above section would output something like

Name,Alias
OBJECTID,OBJECTID
Shape,Shape
AREANAME,AREA NAME
POP2000, POP 2000
"""‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Getting field name and alias list from data set?

LeandraGordon — Fri, 21 Jan 2022 05:10:50 GMT

for f in arcpy.Describe(<TheFeatureClass>).fields:
   if f.name == TheFieldName:
   FIELD_ALIAS = f.aliasName