topic Re: copy joined field in Python Questions

copy joined field

JesseAdams — Mon, 14 Feb 2011 04:19:08 GMT

I'm trying to copy a field from a joined table to feature class. This is easily accomplished in ArcMap with the field calculator or in model builder. However, I can't seem to get it working with Python. Any help would be greatly appreciated. Thanks.

arcpy.MakeFeatureLayer_management(sde_SDE_nuts0, sde_nuts0_view)

    # Process: Join Summary Table to NUTS Poly
    arcpy.AddJoin_management(sde_nuts0_view, "NUTS", "sde_SDE_EU_CTY_SUM_view", "Country_Code_NUTS", "KEEP_COMMON")

    # Process: Copy PotPUMTotal - PotPUMTotal field already exists
    arcpy.CalculateField_management(sde_SDE_nuts0, "PotPUMTotal", "[sde.SDE.EU_CTY_SUM_JSA_Test.SUM_PotPUMTotal]", "VB", "")

It errors with Error #999999?

Re: copy joined field

NiklasNorrthon — Mon, 14 Feb 2011 04:51:23 GMT

Field names should be quoted with exclamation marks, not brackets in python. E.g. !my_field!

Re: copy joined field

JesseAdams — Mon, 14 Feb 2011 11:41:11 GMT

Good point. Rookie error. However, now I receive a "ERROR 000539: Invalid field sde.SDE.EU_CTY_SUM_JSA_Test.SUM_PotPUMTotal" error. Here is the line I'm using now for copying the field from the joined table:

arcpy.CalculateField_management(sde_SDE_nuts0, "PotPUMTotal", "!sde.SDE.EU_CTY_SUM_JSA_Test.SUM_PotPUMTotal!", "Python", "")

When I don't use the table name in front of the field name I get the same error. Any suggestions would be great. Thanks again.

Re: copy joined field

NiklasNorrthon — Mon, 14 Feb 2011 12:16:55 GMT

Try the arcpy.ListFields() function to see how it is spelled.

Re: copy joined field

JesseAdams — Mon, 14 Feb 2011 12:22:08 GMT

Thanks for the reply. I copied the name directly from the ListFields() function output. I'll try again.