nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro field calculator if statements based on value of other field

YusefSamari

I am using ArcGIS Pro 3.1.3. I have a field full of dates, stored as a text field, arranged in the format dd/mm/yyyy. I want to extract the month value and store in a newly created field as an integer. If I just put:

!DateField![3:5]

in the field calculator, without using a code block, the new month field becomes populated, like I want it. However, I only want to extract the values from the date field if the value if the criteria in a DateTypeField, which lists the date type of the record (whether it pertains to specific date, or date range e.g. year), are met. Most of the dates are marked "D" in the date type field and these are the ones I want to populate the new month field for. For all other values of DateTypeField, I want the value of the month field to remain null.

My expression in the Code Block looks like this:

def reclass(Date, DateType):
if (DateType == "D"):
Date[3:5]

With correct indentation, which is lost when copying and pasting into this box. The expression passes the validation check. Then I use the following field calculator expression:

reclass(!DateField!,!DateTypeField!)

And it runs, but all values in the table remain NULL. Can anyone see where I am going wrong? Many thanks.

Find more posts tagged with

Desktop

Accepted answers

DavidSolari

The field calculator doesn't use any types that are pass-by-reference, so you have to return what you want like so:

def reclass(Date, DateType):
    if (DateType == "D"):
        return Date[3:5]
    return None

JoshuaBixby

This can be done with a Python 6.13. Conditional expressions; Python 3.x documentation, aka ternary operator, and doesn't require a code block:

!DateField![3:5] if !DateTypeField! == "D" else None

All comments

DavidSolari

The field calculator doesn't use any types that are pass-by-reference, so you have to return what you want like so:

def reclass(Date, DateType):
    if (DateType == "D"):
        return Date[3:5]
    return None

Richard Howe

The field calculator will also respect a selection and only run on selected rows. So you could do a "select by attributes first (to select records where DateType equals D) and then run your initial calculation

YusefSamari

Many thanks. Just wondering what you mean by 'pass-by-reference', and also, how do you put a codeblock in the text on here?

YusefSamari

Thanks. That would work, but I think an if statement incorporated into field calculator would be easier to incorporate into existing models in modelbuilder in this case.

JoshuaBixby

This can be done with a Python 6.13. Conditional expressions; Python 3.x documentation, aka ternary operator, and doesn't require a code block:

!DateField![3:5] if !DateTypeField! == "D" else None

YusefSamari

Nice! Many thanks.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.