topic Re: How do I get a specific field name with arcpy? in ArcMap Questions

How do I get a specific field name with arcpy?

Anonymous User — Tue, 05 Jan 2021 22:26:09 GMT

I have a geodatabase table with three fields. After creating a list of fields with arcpy, how do I reference just the third field to acquire the fieldname for use in the next arcpy statement?

Re: How do I get a specific field name with arcpy?

JoshuaBixby — Tue, 05 Jan 2021 22:32:21 GMT

>>> l = ["field1", "field2", "field3"] >>> l[2] 'field3' >>>

Re: How do I get a specific field name with arcpy?

DanPatterson — Tue, 05 Jan 2021 22:33:56 GMT

ListFields—ArcGIS Pro | Documentation

assuming

field_names = [f.name for f in arcpy.ListFields(featureclass)] third_fld = field_names[2]

Re: How do I get a specific field name with arcpy?

jrneyulu — Wed, 06 Jan 2021 05:40:42 GMT

This will fail when cursor is fetching mentioned fields only, better to Collect field names from Cursor not from feature class.

Re: How do I get a specific field name with arcpy?

DavidPike — Wed, 06 Jan 2021 13:24:46 GMT

What do you mean by 'mentioned fields'?

Re: How do I get a specific field name with arcpy?

Anonymous User — Wed, 06 Jan 2021 17:45:43 GMT

This is similar to the procedure I came up with yesterday after many trials and errors:

third_fld = arcpy.ListFields(gdb_table)[2]

I could get it to print the name of the correct field with:

print('Field is {0}.'.format(thrid_fld.name))

I could not, however, pass the field name into the JoinField tool with:

arcpy.JoinField_management(fc_in, joinfld1, gdb_table, joinfld2, third_fld)

I'm guessing I am missing something and to simply reference 'third_fld' in the JoinField statement is generating the error:

Runtime error
Traceback (most recent call last):
File "<string>", line 65, in <module>
File "c:\program files (x86)\arcgis\desktop10.8\arcpy\arcpy\management.py", line 6587, in JoinField
raise e
RuntimeError: Object: Error in executing tool

Re: How do I get a specific field name with arcpy?

DanPatterson — Wed, 06 Jan 2021 17:50:56 GMT

third_fld ...thrid_fld ... third_fld

Consistency? Is this a copy-paste issue on your pare or is that what you have in your code?

Re: How do I get a specific field name with arcpy?

DavidPike — Wed, 06 Jan 2021 18:34:16 GMT

Further to Dan's point, you should probably pass third_fld within a list as the last argument.

arcpy.JoinField_management(fc_in, joinfld1, gdb_table, joinfld2, [third_fld])

Re: How do I get a specific field name with arcpy?

Anonymous User — Wed, 06 Jan 2021 19:26:25 GMT

Typing issue - the code was correct.

Re: How do I get a specific field name with arcpy?

Anonymous User — Wed, 06 Jan 2021 19:28:09 GMT

I got this to work. A couple of issues - it never worked in ArcMap but did in Pro. Plus I changed the interpreter within Pycharm to ver 3.7. And added the brackets around third_fld.

Thanks everyone!!

Pam