Arcade Expression - creating an incremental array of non nulls

LukeHaskett — Fri, 21 Feb 2020 13:21:43 GMT

Hi,

Arcade is still very new to me so forgive me if this seems like a basic error. I'm trying to use arcade to loop through the rows of a feature class and return the number of non-null fields for each row. I'm using the following code but it just produces the number of items in the array (3) for each row:

var array = [$feature.Welcoming,$feature.Access,$feature.Community];
var total = 0;
for(var k in array){
Iif(isempty(k),total+=0,total+=1);
}
return total

Would really appreciate some pointers, I can't seem to crack this. So for instance, in a row where two of the variables in the 'array' were null I would expect/need it to return '1' (the number of non-nulls)... equally if one of the variables were null I would need it to return '2'.

Thanks!

Re: Arcade Expression - creating an incremental array of non nulls

XanderBakker — Fri, 21 Feb 2020 19:52:11 GMT

Hi Luke Haskett ,

Have a look at this post by JPC_Planning and my answer there: Using Arcade to count nulls or non-nulls from an array

topic Re: Arcade Expression - creating an incremental array of non nulls in ArcGIS Pro Questions

Arcade Expression - creating an incremental array of non nulls

Re: Arcade Expression - creating an incremental array of non nulls