nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate value in a joined table

AlbertoLaurenti

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

Find more posts tagged with

Accepted answers

FabianBlau

Too much bangs I guess:

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

All comments

AlbertoLaurenti

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

FabianBlau

Too much bangs I guess:

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

AlbertoLaurenti

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.