Null if Statement in Calculated Field

ThomasKelly

I have a column in an attribute table that has a mixture of nulls and data. I wish to create a new column that will return a "yes" if there is data in the column being checked and "no" if it is a null. I have tried a variety of python functions but I keep getting an error similar to the below:

 

ERROR 000539: File "<expression>", line 1
updateValue(1E+21.0)
^
SyntaxError: invalid syntax
Failed to execute (CalculateField).   

I have tried the following :

X = updateValue(!field!)

def updateValue(value):
   if value == None:
   return 'no'
   else: return "yes"

Any help would be most appreciated. 

JoshuaBixby

This question seems to come up in one form or another about every 6 months on GeoNet.  I think it is important to understand what Dan is pointing out.  Additionally, you can use a Python conditional expression to achieve the result while not needing to define a code block:

<SPAN class="string token">"NO"</SPAN> <SPAN class="keyword token">if</SPAN> !field! <SPAN class="keyword token">is</SPAN> None <SPAN class="keyword token">else</SPAN> <SPAN class="string token">"YES"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>