topic Re: Problem using IIf in Arcade label expression to check if field is Null in ArcGIS Pro Questions

Problem using IIf in Arcade label expression to check if field is Null

MattSmithCarto — Tue, 22 Feb 2022 23:39:46 GMT

Trying to label this feature class on it's Name field. If the Name field is Null then I want to place custom text.

This is what I have:

var name = $feature.name
IIf(IsEmpty(name) == False, name, 'landing ground')

But it only seems to label the True part of the statement and not the False, so I see the name, but not the text "landing ground" (image 2).

This seems really basic stuff, so can't work out why it's not working like I think it should.

jcarlson — Tue, 22 Feb 2022 23:50:21 GMT

IsEmpty evaluates to a boolean, and "!" negates a condition, so you can re-write that as

Iif(!IsEmpty(name), name, 'landing ground')

But what you're essentially doing is replicating the function DefaultValue. Try this:

DefaultValue(name, 'landing ground')

MattSmithCarto — Wed, 23 Feb 2022 00:25:00 GMT

Thanks @jcarlson but that's yielding the exact same result. I'm still missing labels for records with the Null value

MattSmithCarto — Wed, 23 Feb 2022 00:33:56 GMT

OK, clearly I wasn't awake! I had a SQL limiting which records were being returned. Rookie error.

Thanks for your help!

jcarlson — Wed, 23 Feb 2022 00:42:44 GMT

Ah! That was my next question! Always nice when it's a simple solution.