#arcpy #python #modelbuilder #fieldcalculator
The GeoNet Help space is for help with GeoNet itself, not for general help from GeoNet users. I am sharing this with https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=f7391898-3f52-4821-b96a-efef47fd4a3c&searchIndex=1 and https://community.esri.com/community/gis?sr=search&searchId=5fac74d6-fe0d-44df-ae1e-04a3cc2b532e&searchIndex=2.
Are you using ArcMap or ArcGIS Pro? What version? What is the backend data store for the table, shapefile, file geodatabase, enterprise geodatabase? It looks like you are using Model Builder, can you share either the whole model or a subset of it?
I exported the code from modelbuilder but it gives me the error above. Below is the python code.# Import arcpy module2import arcpy
# Local variables:Outlets = "D:\\Apps\\Retail\\LA_Working\\ABUZAR_WORKING\\PORTAL\\LA_Daily.gdb\\Outlets"Outlets_PointDistance = "D:\\Apps\\Retail\\LA_Working\\ABUZAR_WORKING\\MYTESTS\\MyScratchWorkSpace\\MyScratch.gdb\\Outlets_PointDistance"Outlets_PointDistance__6_ = Outlets_PointDistanceOutlets_PointDistance__5_ = Outlets_PointDistance__6_Outlets__3_ = "D:\\Apps\\Retail\\LA_Working\\ABUZAR_WORKING\\PORTAL\\LA_Daily.gdb\\Outlets"Outlets_PointDistance__3_ = Outlets__3_Outlets_PointDistance__2_ = Outlets_PointDistance__3_Outlets_PointDistance_10km_ODMatrix = "D:\\Apps\\Retail\\LA_Working\\ABUZAR_WORKING\\MYTESTS\\MyScratchWorkSpace\\MyScratch.gdb\\Outlets_PointDistance_10km_ODMatrix"Delete_succeeded = "true"
# Process: Point Distancearcpy.PointDistance_analysis(Outlets, Outlets, Outlets_PointDistance, "10 Kilometers")
# Process: Add Fieldarcpy.AddField_management(Outlets_PointDistance, "COSTCENTREREL_ID", "TEXT", "", "", "12", "", "NULLABLE", "NON_REQUIRED", "")
# Process: Join INPUT Cost CentretempEnvironment0 = arcpy.env.newPrecisionarcpy.env.newPrecision = "SINGLE"tempEnvironment1 = arcpy.env.autoCommitarcpy.env.autoCommit = "1000"tempEnvironment2 = arcpy.env.XYResolutionarcpy.env.XYResolution = ""tempEnvironment3 = arcpy.env.XYDomainarcpy.env.XYDomain = ""tempEnvironment4 = arcpy.env.scratchWorkspacearcpy.env.scratchWorkspace = "D:\\Apps\\Retail\\TOOLS\\CALLFOR_WEEKLY\\ScratchWorkSpace\\Scratch.gdb"tempEnvironment5 = arcpy.env.cartographicPartitionsarcpy.env.cartographicPartitions = ""tempEnvironment6 = arcpy.env.terrainMemoryUsagearcpy.env.terrainMemoryUsage = "false"tempEnvironment7 = arcpy.env.MTolerancearcpy.env.MTolerance = ""tempEnvironment8 = arcpy.env.compressionarcpy.env.compression = "LZ77"tempEnvironment9 = arcpy.env.coincidentPointsarcpy.env.coincidentPoints = "MEAN"tempEnvironment10 = arcpy.env.randomGeneratorarcpy.env.randomGenerator = "0 ACM599"tempEnvironment11 = arcpy.env.outputCoordinateSystemarcpy.env.outputCoordinateSystem = ""tempEnvironment12 = arcpy.env.rasterStatisticsarcpy.env.rasterStatistics = "STATISTICS 1 1"tempEnvironment13 = arcpy.env.ZDomainarcpy.env.ZDomain = ""tempEnvironment14 = arcpy.env.transferDomainsarcpy.env.transferDomains = "false"tempEnvironment15 = arcpy.env.resamplingMethodarcpy.env.resamplingMethod = "NEAREST"tempEnvironment16 = arcpy.env.snapRasterarcpy.env.snapRaster = ""tempEnvironment17 = arcpy.env.projectComparearcpy.env.projectCompare = "NONE"tempEnvironment18 = arcpy.env.cartographicCoordinateSystemarcpy.env.cartographicCoordinateSystem = ""tempEnvironment19 = arcpy.env.configKeywordarcpy.env.configKeyword = ""tempEnvironment20 = arcpy.env.outputZFlagarcpy.env.outputZFlag = "Same As Input"tempEnvironment21 = arcpy.env.qualifiedFieldNamesarcpy.env.qualifiedFieldNames = "true"tempEnvironment22 = arcpy.env.tileSizearcpy.env.tileSize = "128 128"tempEnvironment23 = arcpy.env.parallelProcessingFactorarcpy.env.parallelProcessingFactor = ""tempEnvironment24 = arcpy.env.pyramidarcpy.env.pyramid = "PYRAMIDS -1 NEAREST DEFAULT 75 NO_SKIP"tempEnvironment25 = arcpy.env.referenceScalearcpy.env.referenceScale = ""tempEnvironment26 = arcpy.env.extentarcpy.env.extent = "DEFAULT"tempEnvironment27 = arcpy.env.XYTolerancearcpy.env.XYTolerance = ""tempEnvironment28 = arcpy.env.tinSaveVersionarcpy.env.tinSaveVersion = "CURRENT"tempEnvironment29 = arcpy.env.nodataarcpy.env.nodata = "NONE"tempEnvironment30 = arcpy.env.MDomainarcpy.env.MDomain = ""tempEnvironment31 = arcpy.env.spatialGrid1arcpy.env.spatialGrid1 = "0"tempEnvironment32 = arcpy.env.cellSizearcpy.env.cellSize = "MAXOF"tempEnvironment33 = arcpy.env.outputZValuearcpy.env.outputZValue = ""tempEnvironment34 = arcpy.env.outputMFlagarcpy.env.outputMFlag = "Same As Input"tempEnvironment35 = arcpy.env.geographicTransformationsarcpy.env.geographicTransformations = "NAD_1927_To_NAD_1983_NADCON"tempEnvironment36 = arcpy.env.spatialGrid2arcpy.env.spatialGrid2 = "0"tempEnvironment37 = arcpy.env.ZResolutionarcpy.env.ZResolution = ""tempEnvironment38 = arcpy.env.maskarcpy.env.mask = ""tempEnvironment39 = arcpy.env.spatialGrid3arcpy.env.spatialGrid3 = "0"tempEnvironment40 = arcpy.env.maintainSpatialIndexarcpy.env.maintainSpatialIndex = "false"tempEnvironment41 = arcpy.env.workspacearcpy.env.workspace = "D:\\Apps\\Retail\\TOOLS\\CALLFOR_WEEKLY\\ToolData\\CallForWeekly.gdb"tempEnvironment42 = arcpy.env.MResolutionarcpy.env.MResolution = ""tempEnvironment43 = arcpy.env.derivedPrecisionarcpy.env.derivedPrecision = "HIGHEST"tempEnvironment44 = arcpy.env.ZTolerancearcpy.env.ZTolerance = ""arcpy.JoinField_management(Outlets_PointDistance__6_, "INPUT_FID", Outlets__3_, "OBJECTID", "Rcnumber")arcpy.env.newPrecision = tempEnvironment0arcpy.env.autoCommit = tempEnvironment1arcpy.env.XYResolution = tempEnvironment2arcpy.env.XYDomain = tempEnvironment3arcpy.env.scratchWorkspace = tempEnvironment4arcpy.env.cartographicPartitions = tempEnvironment5arcpy.env.terrainMemoryUsage = tempEnvironment6arcpy.env.MTolerance = tempEnvironment7arcpy.env.compression = tempEnvironment8arcpy.env.coincidentPoints = tempEnvironment9arcpy.env.randomGenerator = tempEnvironment10arcpy.env.outputCoordinateSystem = tempEnvironment11arcpy.env.rasterStatistics = tempEnvironment12arcpy.env.ZDomain = tempEnvironment13arcpy.env.transferDomains = tempEnvironment14arcpy.env.resamplingMethod = tempEnvironment15arcpy.env.snapRaster = tempEnvironment16arcpy.env.projectCompare = tempEnvironment17arcpy.env.cartographicCoordinateSystem = tempEnvironment18arcpy.env.configKeyword = tempEnvironment19arcpy.env.outputZFlag = tempEnvironment20arcpy.env.qualifiedFieldNames = tempEnvironment21arcpy.env.tileSize = tempEnvironment22arcpy.env.parallelProcessingFactor = tempEnvironment23arcpy.env.pyramid = tempEnvironment24arcpy.env.referenceScale = tempEnvironment25arcpy.env.extent = tempEnvironment26arcpy.env.XYTolerance = tempEnvironment27arcpy.env.tinSaveVersion = tempEnvironment28arcpy.env.nodata = tempEnvironment29arcpy.env.MDomain = tempEnvironment30arcpy.env.spatialGrid1 = tempEnvironment31arcpy.env.cellSize = tempEnvironment32arcpy.env.outputZValue = tempEnvironment33arcpy.env.outputMFlag = tempEnvironment34arcpy.env.geographicTransformations = tempEnvironment35arcpy.env.spatialGrid2 = tempEnvironment36arcpy.env.ZResolution = tempEnvironment37arcpy.env.mask = tempEnvironment38arcpy.env.spatialGrid3 = tempEnvironment39arcpy.env.maintainSpatialIndex = tempEnvironment40arcpy.env.workspace = tempEnvironment41arcpy.env.MResolution = tempEnvironment42arcpy.env.derivedPrecision = tempEnvironment43arcpy.env.ZTolerance = tempEnvironment44
# Process: Join Fieldarcpy.JoinField_management(Outlets_PointDistance__5_, "NEAR_FID", Outlets__3_, "OBJECTID", "Rcnumber")
# Process: Calculate Fieldarcpy.CalculateField_management(Outlets_PointDistance__5_, "COSTCENTREREL_ID", "!Rcnumber!+ !Rcnumber_1!", "PYTHON_9.3", "")
# Process: Copy Rowsarcpy.CopyRows_management(Outlets_PointDistance__2_, Outlets_PointDistance_10km_ODMatrix, "")
# Process: Deletearcpy.Delete_management(Outlets_PointDistance, "")
You are running arcpy.JoinField_management right before arcpy.CalculateField_management. Depending on the backend data stores and fields in the tables, there can be situations where the fully qualified name is required, e.g., table_name.field_name instead of just field_name.
As an experiment, what if you don't do the join and see if you can calculate the field to some arbitrary number. Does that work?
To expand on what Joshua Bixby mentioned, check out Qualified Field Names (Environment setting)—Help | ArcGIS Desktop
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
