topic Re: Retaining Field Names in Python Questions

Retaining Field Names

TychoGranville — Tue, 05 Nov 2013 20:26:46 GMT

Just finished the Python web class, and I???m stuck....

I have a Feature Class with a table joined to it.

If I use ArcMap to manually export the FC to a shapefile (TOC --> right-click FC --> Data --> Export Data) I get a new file with the new fields all having the names of the previously joined table fields (so, Owner, Care_Of, etc)

If I use any type of Python command (FeatureClassToFeatureClass_conversion, Project_management, Clip_analysis) in that same MXD the field names change to the name of the table they came from, followed by a number (so, ParcelJo_1, ParcelJo_2, etc)

What command am I missing to keep the original field names?

Thanks,
Tycho

Re: Retaining Field Names

T__WayneWhitley — Wed, 06 Nov 2013 01:05:45 GMT

If I'm not mistaken you need to use unqualified field names...that's an environment setting, see the sample script in the web help:

Qualified Field Names (Environment setting)
Desktop » Geoprocessing » Environment settings
http://resources.arcgis.com/en/help/main/10.2/index.html#//001w00000008000000

The default value is 'True' so you have to set it to 'False' - here's an excerpt:

import arcpy arcpy.env.qualifiedFieldNames = False

Hope that helps.

Enjoy,
Wayne

Re: Retaining Field Names

TychoGranville — Wed, 06 Nov 2013 15:07:37 GMT

Awesome - that's exactly what I needed!

Tycho