Make CalculatedField with join between feature class and table from gdb

LouisDECOMBE

Hi, 

I tried to make calculatedfield on a field of the feature classe that was joined with a table but does not success.

Can anyone help me to write correctly the expression.

Thank you very much

# Set environment settings
arcpy.env.workspace = r"C:\Users\Folder"
arcpy.env.qualifiedFieldNames = False

# Set local variables
inFeatures = r"C:\Users\Folder\Name.gdb\FC"
layerName = "FC"
joinTable = r"C:\Users\Folder\Name.gdb\Table_iris_france"
tableName= "table_iris"
joinField = "ID"
joinField2 = "CODE_IRIS"
field1="POP_COURANT"

# Create a feature layer from the vegtype featureclass
arcpy.MakeFeatureLayer_management (inFeatures, layerName)

# Make a table view from the table
arcpy.MakeTableView_management(joinTable, tableName)

# Join the feature layer to a table
arcpy.AddJoin_management(layerName, joinField, joinTable, joinField2)

# Process: Calculer un champ
arcpy.CalculateField_management(layerName, "Pop_COURANT", "!"+tableName+".POP_COURANT2!", "PYTHON")

2017-06-26_12h31_44.png

DanPatterson_Retired

if it worked properly manually, go to your Results output and check your syntax vs works there.  It is a useful option and one that will save a lot of time trying to debug syntax that appears to be correct vs what actually works.