topic Re: Calculate value in a joined table in Python Questions

Calculate value in a joined table

AlbertoLaurenti — Thu, 28 Nov 2013 07:12:55 GMT

Hi,
I've to calculate a field based on another field in a joined table, but an error occurs:

"Parameters are not valid.
ERROR 000728: Field !Table_A.field_A! does not exist within table"

import arcpy from arcpy import env env.workspace = "C:/TMP/BASELINE.gdb" Table_A = "dist" Table_B= "matrix" arcpy.AddJoin_management(Table_A, "id_grid", Table_B, "id_matrix") arcpy.CalculateField_management(Table_A, "!" + Table_A + ".field_A!", "!" + Table_B + ".field_B!","PYTHON")

Both tables are in the BASELINE.gdb. The Join occurs without any problem.

Please, any help appreciated.
Thanks in advance

Re: Calculate value in a joined table

AlbertoLaurenti — Thu, 28 Nov 2013 09:14:19 GMT

I forgot to say that, of course, "field_A" exists in "Table_A" and "field_B" exists in "Table_B".
Last but not least, if I run the same calculation in Arcmap, using Field Calculator, no error occur.

Thanks

Re: Calculate value in a joined table

FabianBlau — Thu, 28 Nov 2013 10:22:40 GMT

Too much bangs I guess:

arcpy.CalculateField_management(Table_A, Table_A + ".field_A", "!" + Table_B + ".field_B!","PYTHON")

Re: Calculate value in a joined table

AlbertoLaurenti — Thu, 28 Nov 2013 11:43:19 GMT

Ooops, you're right!!
Now it works perfectly. Thank you