topic Joined Fields names in Python Questions

Joined Fields names

OlivierOlivier — Mon, 05 Mar 2012 17:13:31 GMT

Hi,

With 10.0, I thought it was possible to use directly field names instead of getvalue/setvalue to get fields values. Problem comes with joined layer :

I use rows=searchCursor("joined layer") and try for row in rows...

If I use the field name only (row.field_name), it's unknown, and if I use row.table_name.field_name, I get the error field "table_name" is unknown. I tried to set arcpy.env.qualifiedFieldNames either to True of False, but nothing worked out. Perhaps I need to set other delimiters ?

Thanks for any help

Olivier

Re: Joined Fields names

MathewCoyle — Sat, 11 Dec 2021 14:44:18 GMT

For joined tables you still have to use the getVaue statement I am fairly certain.

cur = arcpy.SearchCursor(layer)
for row in cur:
     row.getValue("JoinedTableName.FieldName")

Re: Joined Fields names

OlivierOlivier — Mon, 05 Mar 2012 18:04:28 GMT

Hi Mathew,

Thanks, I hoped it could solve this problem of querying joined fields which works with SearchCursor but not with UpdateCursor... Never mind !

Olivier