nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade expression to find min() not zero

SeanSummers_CC

Hi! I am trying to get familiar with the new Arcade language. Specifically as used in Attribute Rules.

I am trying to create an Arcade expression to calculate a field in ArcGIS Pro. In my streets feature there are 4 number fields to evaluate. I can easily use the Min() function to do this. The problem that I am having is sometimes there is a 0 in one or more fields. I need the lowest number that is not a 0. In python I had this script which worked well:

<SPAN class="">min</SPAN><SPAN class="">([</SPAN><SPAN class="">x </SPAN><SPAN class="">for</SPAN><SPAN class=""> x in </SPAN><SPAN class="">(</SPAN><SPAN class=""> </SPAN><SPAN class="">!</SPAN><SPAN class="">L_F_ADD</SPAN><SPAN class="">!,</SPAN><SPAN class=""> </SPAN><SPAN class="">!</SPAN><SPAN class="">L_T_ADD</SPAN><SPAN class="">!,</SPAN><SPAN class=""> </SPAN><SPAN class="">!</SPAN><SPAN class="">R_F_ADD</SPAN><SPAN class="">!,</SPAN><SPAN class=""> </SPAN><SPAN class="">!</SPAN><SPAN class="">R_T_ADD</SPAN><SPAN class="">!)</SPAN><SPAN class=""> </SPAN><SPAN class="">if</SPAN><SPAN class=""> x is not </SPAN><SPAN class="">0</SPAN><SPAN class="">])</SPAN>

I have tried redoing this in Arcade but can't figure it out. Any ideas?

Find more posts tagged with

Accepted answers

XanderBakker

Hi spsummers ,

You are probably not going to like it, but those powerful python list comprehensions are not available in arcade. Can you try this?

<SPAN class="keyword token">var</SPAN> minv <SPAN class="operator token">=</SPAN> <SPAN class="number token">99999</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> arr <SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>$feature<SPAN class="punctuation token">[</SPAN>L_F_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_T_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_F_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_T_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="keyword token">in</SPAN> arr<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> v <SPAN class="operator token">=</SPAN> arr<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>v<SPAN class="operator token">!=</SPAN><SPAN class="number token">0</SPAN> <SPAN class="operator token">&&</SPAN> <SPAN class="operator token">!</SPAN><SPAN class="token function">IsEmpty</SPAN><SPAN class="punctuation token">(</SPAN>v<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>v <SPAN class="operator token"><</SPAN> minv<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            minv <SPAN class="operator token">=</SPAN> v<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>minv <SPAN class="operator token">==</SPAN> <SPAN class="number token">99999</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>    
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> minv<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

XanderBakker

Hi spsummers ,

That is correct, I thought about this too, but I didn't know if you had any negative values to consider. Thanks for sharing.

SeanSummers_CC

Thank you! Your code worked. I also asked this question on another forum (Geographic Information Systems Stack Exchange ) The solution presented by Hornbydd is this:

var inArray = [$feature.FromAddr_L,$feature.ToAddr_L,$feature.FromAddr_R,$feature.ToAddr_R];
var sortedArray;
sortedArray = sort(inArray);
for(var i in sortedArray)
{
if (sortedArray > 0) break;        
}
return sortedArray;<SPAN class="">
</SPAN>

Both solutions work in the Field Calculator. It will be interesting to see if they work in the Attribute Rules.
<SPAN class=""><BR /></SPAN>

Thank you!

XanderBakker

Hi spsummers ,

You are probably not going to like it, but those powerful python list comprehensions are not available in arcade. Can you try this?

<SPAN class="keyword token">var</SPAN> minv <SPAN class="operator token">=</SPAN> <SPAN class="number token">99999</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> arr <SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>$feature<SPAN class="punctuation token">[</SPAN>L_F_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_T_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_F_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN>L_T_ADD<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="keyword token">in</SPAN> arr<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> v <SPAN class="operator token">=</SPAN> arr<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>v<SPAN class="operator token">!=</SPAN><SPAN class="number token">0</SPAN> <SPAN class="operator token">&&</SPAN> <SPAN class="operator token">!</SPAN><SPAN class="token function">IsEmpty</SPAN><SPAN class="punctuation token">(</SPAN>v<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>v <SPAN class="operator token"><</SPAN> minv<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            minv <SPAN class="operator token">=</SPAN> v<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>minv <SPAN class="operator token">==</SPAN> <SPAN class="number token">99999</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>    
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> minv<SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.