Arcade Expression "if/then" statement

AndyBohnhoff

I am looking to create an expression in Arcade using multiple "if/then" statements. The issue I am running into is trying to use "AND" in between statements. I currently have a flag if the bench is identical or not. It looks like this:

if ($feature.toe_target_caps==
$feature.target_formation) {return 1}
else {return 0}

What I need to do next is say

if target_formation = "NIOBRARA A" and toe_target_caps = "NIOBRARA B" = 2

if target_formation = "NIOBRARA B" and toe_target_caps = "NIOBRARA C" = 3

if target_formation = "NIOBRARA A" and toe_target_caps = "NIOBRARA C" = 4

else {return 0}

So ideally I would have flags 5 flags (0-4). Thanks!

LanceCole

Andy,‌

You can try the following samples but there are a few holes in the logic from the sample you provided.  For example "NIOBRARA A" and "CODELL", "NIOBRARA B" and "CODELL", "NIOBRARA B" and "NIOBRARA A", "CODELL" and "NIOBRARA A", etc. will all result in a return of 0.  Is this what you wanted? If not, you can expand the conditional statements to include these as well.  The first example use && for (and) and if was need || for (or).

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> $feature<SPAN class="punctuation token">.</SPAN>toe_target_caps<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">return</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA A"</SPAN> <SPAN class="operator token">&&</SPAN> $feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA B"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">return</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA B"</SPAN> <SPAN class="operator token">&&</SPAN> $feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA C"</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">return</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA A"</SPAN> <SPAN class="operator token">&&</SPAN> $feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA C"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">return</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="keyword token">return</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This second example has the same output but is based upon grouped and nested conditional statements

<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> $feature<SPAN class="punctuation token">.</SPAN>toe_target_caps<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
  <SPAN class="keyword token">return</SPAN> <SPAN class="number token">1</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA A"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
  <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA B"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="number token">2</SPAN>
  <SPAN class="punctuation token">}</SPAN>
  <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA C"</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="number token">4</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>target_formation <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA B"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
  <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>toe_target_caps <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NIOBRARA C"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="number token">3</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> <SPAN class="number token">0</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>‍</SPAN><SPAN>‍</SPAN></SPAN>