topic Re: arcade if, else (do nothing) in ArcGIS Pro Questions

arcade if, else (do nothing)

Gisbert61 — Tue, 28 Jul 2020 07:48:40 GMT

I'm filling in some missing attributes in a feature layer using 'calculate field' and I tried:

and this works, kind of. Empty fields gets filled in with '3' but any field already filled are emptied and <null> afterwards.

So for the moment I have:

which covers all possible values (in the coded value domain on this attribute). This works but is cumbersome.

What I would like to do is something like

How can I achieve this ... else do nothing ... ?

Thanks in advance for your time.

Bert Kraan

Re: arcade if, else (do nothing)

JoshuaSharp-Heward — Tue, 28 Jul 2020 08:24:40 GMT

Hi Bert,

You can simply add the line "return $feature.verharding" to the else clause, which means for all other values it will just return the existing value.

Note, a better way to do this would be to use the IIF arcade function detailed here: Logical Functions | ArcGIS for Developers to do it in one line!

Re: arcade if, else (do nothing)

HåkonDreyer — Tue, 28 Jul 2020 08:26:47 GMT

Hi, Bert

Guess the easiest will be to select all null values using Select by attributes, and then run the calculation using your initial code on the selected set.

Alternatively, you may send the value to the field calculator using:

Re: arcade if, else (do nothing)

Egge-Jan_Pollé — Sat, 11 Dec 2021 10:15:05 GMT

Hi Bert Kraan,

I was actually going to come up with the first solution given by Joshua Sharp-Heward, but from the same answer I learned about the IIf() function.

That's why it is so good to follow this forum, to learn a little every day (very kaizen!).

So, to wrap up:

Simple solution	One line solution
`if (IsEmpty($feature.verharding)) { return 3; } else { return $feature.verharding; }‍‍‍‍‍`	`IIf (IsEmpty($feature.verharding), 3, $feature.verharding);‍‍‍‍‍`

HTH,

Egge-Jan

Re: arcade if, else (do nothing)

Gisbert61 — Tue, 28 Jul 2020 10:00:27 GMT

Thanks all for three great answers from all over the globe!

Bert

Re: arcade if, else (do nothing)

JJ_Reyes — Mon, 25 Sep 2023 15:14:26 GMT

This is a good solution, but it does change the edit date on the records as if they were actually calculated. I wonder if there is another way to do this (when selecting a set first is not an option)?

Re: arcade if, else (do nothing)

MDB_GIS — Wed, 02 Oct 2024 12:44:10 GMT

Long out of date, but thanks to you and @JoshuaSharp-Heward for mentioning IIF statements. I was able to greatly streamline some of my attribute rules using this newfound knowledge!

Re: arcade if, else (do nothing)

JoshuaBixby — Wed, 02 Oct 2024 14:30:15 GMT

I am pretty sure you are out of luck, and it isn't just an Arcade limitation. Calculate Field has to return something for each record, there is no way to tell Calculate Field to stop processing the current record and move onto the next.