Update Field with condition not working

rajujee

Hi,

I spent half day and didn't resolve issue. I need to update field Grave if it is null. My code is below. I am using python. I have attached error details. please help!

Logic

def myfun(myvalue):
if myvalue != !ABC_ID!:
return !ABC_NO!

Field

Grave=myfun(!H_No!)

Syntax Error.jpg

survey_minimalbug.PNG

PLadd_3-1729600851192.png

RhettZufelt

How to insert code....

You didn't say what you  want to update to if Null.  So, this updates to the value in ABC_NO field.

def myfun(myvalue,retvalue):
    if myvalue is None:
        return retvalue
    else: 
        return myvalue

Field Grave=
    
myfun(!Grave!,!ABC_NO!)

 

R_