topic Re: If-then statement in field calculator in Geoprocessing Questions

If-then statement in field calculator

Anonymous User — Mon, 20 Jul 2015 21:13:55 GMT

I am new to scripting and am trying to figure out how to write an If-then statement to populate a field in field calculator. I want to basically say if a certain field has a NULL value in it, then the result is "No" in that field. If the certain field has a value in it, then I want the result to be "Yes".

Re: If-then statement in field calculator

JoeBorgione — Mon, 20 Jul 2015 21:22:40 GMT

Not sure it's possible; my work around has always been to create a selection and calc your value.

select: 'TheField' is null

Re: If-then statement in field calculator

IanMurray — Mon, 20 Jul 2015 21:23:20 GMT

It would be something like this.

Expression:

Reclass(!FieldwithNullValuesHere!)

Expression Type:

Python_9.3

Code Block:

def Reclass(field):

if field == "None":

return "No"

else:

return "Yes"

Re: If-then statement in field calculator

DarrenWiens2 — Sat, 11 Dec 2021 07:01:21 GMT

This is assuming your field is actually <Null>, not blank, or something else:

Codeblock:

def blah(field):
  if field:
    return "Yes"
  else:
    return "No"

expression:

blah(!yourfield!)

Re: If-then statement in field calculator

FreddieGibson — Mon, 20 Jul 2015 22:14:59 GMT

See the following Esri Documentation and look for the section titled "Using Code Blocks"

Calculate Field Examples

http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/calculate-field-examples.htm

Re: If-then statement in field calculator

Anonymous User — Tue, 21 Jul 2015 15:36:17 GMT

Thank you everyone for your help! I was able to accomplish what I wanted by doing a selection query and field calculating on the results.