topic Re: Arcade expression to exclude fields that are null in ArcGIS Pro Questions

Arcade expression to exclude fields that are null

hhmpo — Fri, 18 Nov 2022 17:16:02 GMT

Hello,

I am quite a noobie to the expression labeling. I have done some traffic counts at an intersection and was wanting to label each direction according to the ADT and MPH. I am having trouble figuring out how to exclude any null data. I have attached a picture.
Here is my expression in arcade language.
Thank your for your time.

$feature.North + ' NB ' + $feature.eightyfifth + ' MPH ' + TextFormatting.NewLine + $feature.South + ' SB ' + $feature.eightyfift + ' MPH ' + TextFormatting.NewLine + $feature.East + ' EB ' + $feature.eighty + ' MPH ' +
TextFormatting.NewLine + $feature.West + ' WB ' + $feature.eightfive + ' MPH '

Re: Arcade expression to exclude fields that are null

DuncanHornby — Fri, 18 Nov 2022 17:27:32 GMT

See Q&A here.

Re: Arcade expression to exclude fields that are null

KenBuja — Tue, 22 Nov 2022 14:38:33 GMT

You'll have to build your expression by checking the values for each of the attributes. This example assumes that if the ADT is empty, its speed will also be empty. If not, you'll have to check for those separately. It also uses template literals.

var output; if (!IsEmpty($feature.North)) output += `${$feature.North} NB ${$feature.eightyfifth} MPH\n`; if (!IsEmpty($feature.South)) output += `${$feature.South} SB ${$feature.eightyfift} MPH\n`; if (!IsEmpty($feature.East)) output += `${$feature.East} EB ${$feature.eighty} MPH\n`; if (!IsEmpty($feature.West)) output += `${$feature.West} WB ${$feature.eightfive} MPH\n`; return Left(output, Count(output) - 1); //this removes the last carriage return

Re: Arcade expression to exclude fields that are null

hhmpo — Mon, 21 Nov 2022 23:08:53 GMT

Hello, thank you.

You are correct, if ADT is empty then Speed is empty.
but I am getting invalid expression. error on line 7. expected array or feature set

Re: Arcade expression to exclude fields that are null

KenBuja — Tue, 22 Nov 2022 14:24:48 GMT

Can you post the code you're using? I tested this code and it's working fine.