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

232
1
05-17-2021 01:03 PM
KieranClark
Occasional Contributor

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:

sqlhelppls.png

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):

sqlArcGISWorking.png

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.

0 Kudos
1 Reply
dgiersz_cuyahoga
New Contributor III

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