Frequently asked question

How can I check for null values in the Field Calculator using Python?

Last Published: November 16, 2021

Answer

Starting at ArcGIS for Desktop 10.1, null values in an attribute table are returned as the string 'None' in the Field Calculator using Python. Knowing this, an if/elif statement can be used to find whether values are null or not. Here is an example script that checks if a field contains null values:

Expression:
findNulls(!fieldA!)

Expression Type:
PYTHON_9.3

Code Block:
def findNulls(fieldValue):
    if fieldValue is None:
        return "null values"
    elif fieldValue is not None:
        return "no nulls here"

Article ID: 000011740

Software:
  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options