Arcade help - Return "Not Available" when no values exist

KieranClark — Mon, 17 May 2021 20:41:40 GMT

This is a bit of a follow up to this post:

Solved: Re: Removing blank values via Arcade Expression - Esri Community

I now have the comma separated lists working with blank values removed. However, for entries where no appropriate company exists for that entry, I would like to return "Not Available" instead of simply leaving the value blank.

Here's what it currently looks like:

The blank spot next to "System Installer" is what I would like to have say "Not Available" if there are no matches.

Currently, the field is set up like so (this is the same way for Supplier/Owners):

This works perfectly when there are existing values for this entry in the map series. However, for entries that do not have a matching ROLE_ID I can't figure out how to return "Not Available" instead of just leaving it blank.

I don't feel like I'm explaining this particularly well either, so please feel free to ask more pointed questions to help figure out the root of the issue.

Re: Arcade help - Return "Not Available" when no values exist

dgiersz_cuyahoga — Tue, 18 May 2021 12:06:09 GMT

I would try something like IIf(IsEmpty(ROLE_ID),'Not Available',$feature.ROLE_ID)

topic Re: Arcade help - Return "Not Available" when no values exist in ArcGIS Pro Questions

Arcade help - Return "Not Available" when no values exist

Re: Arcade help - Return "Not Available" when no values exist