topic Re: Add a fieldname instead of value in calculate field using Python in ArcGIS Pro Questions

Add a fieldname instead of value in calculate field using Python

LakshmiSankaran — Wed, 10 Feb 2021 21:41:51 GMT

I am trying to convert this VB script in a model from ArcMap (10.7.1) to a model in ArcGIS Pro (3.7).

Calculating a field ADD1, and using values from a field ADD2:

Dim MainAddress
If Not [ADD1]= "" Then
MainAddress = MainAddress
Else
MainAddress = [ADD2]
End if

______

I attempted this in the ArcGIS Pro codeblock: and was unable to replace the value with the fields ADD1 or ADD2, so tried a text value instead to see if the logic at least was correct.

Runs as below, but how do I replace the value with values from another field?

def replace(mainaddress):
if (mainaddress != ""):
value = '5'
elif (mainaddress == ""):
value = '99'
return value

I have written the alternate select by attributes -> calculate, but I have a bunch of fields that need this kind of calculation.

Arcade solution welcome as an alternative..

Lakshmi

Re: Add a fieldname instead of value in calculate field using Python

DanPatterson — Wed, 10 Feb 2021 22:09:57 GMT

Code formatting ... the Community Version - GeoNet, The Esri Community

def replace(mainaddress): if (mainaddress != ""): value = '5' elif (mainaddress == ""): value = '99' return value

Now... mainaddress can't be your field name, it can be a variable.

See the examples in this topic

Calculate Field (Data Management)—ArcGIS Pro | Documentation

my_code = """ def replace(mainaddress): if (mainaddress != ""): value = '5' elif (mainaddress == ""): value = '99' return value """

Re: Add a fieldname instead of value in calculate field using Python

DavinWalker2 — Wed, 10 Feb 2021 22:37:11 GMT

I hope the below helps.

This will replace the field I'm running the calculate field on with the value from the CODE field if the PLANT_ AREA field is not empty and replace it with the vale from field MEAN_AREA if it is empty.

Re: Add a fieldname instead of value in calculate field using Python

LakshmiSankaran — Thu, 11 Feb 2021 14:14:33 GMT

Thank you!

Lakshmi

Re: Add a fieldname instead of value in calculate field using Python

DavinWalker2 — Fri, 12 Feb 2021 06:10:36 GMT

You welcome.