Use Calcuate Field to replace values

JohnBrand — Thu, 19 Sep 2019 15:17:46 GMT

I'm trying to use the Field Calculator (python) to replace existing values (string) in Field1 with the values in Field2 (string) but only if Field2 is not Null.

Having trouble with the syntax.

Thanks,

John

Re: Use Calcuate Field to replace values

LanceCole — Sat, 11 Dec 2021 11:51:00 GMT

John,

In Field Calculator you will want to create a def statement in the code block and pass the values of Field1 and Field2 to this statement. The Statement will look something like the following:

def checkValue(f1, f2):
  if f2 is None:
    return f1
  else:
    return f2
‍‍‍‍‍‍‍‍‍‍‍

You would call the function using:

checkValue(!field1!, !field2!)

topic Use Calcuate Field to replace values in Geoprocessing Questions

Use Calcuate Field to replace values

Re: Use Calcuate Field to replace values