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; } } }

If conditional Expression

CarlosPires2

I need to fill a field using an expression, but including a condition.

I have two fields:

GRIDCODE (field reference, unique values from 0 to 2"

ERRO - blank field I would fill as follow:

If GRIDCODE value is 0, then ERRO value is: "Não há diferença"

If GRIDCODE value is 1, then ERRO value is: "Área de uso consolidado cadastrada como nativa"

If GRIDCODE value is 2, then ERRO value is: "Área de vegetação nativa cadastrada como uso consolidado"

I tried use this expression, but it doens´t work.. looks like it has a sintaxe error.

If [GRIDCODE] = 0 Then
[Erro] = "Não há diferença"
ELSEIF [GRIDCODE] = 1 Then
[Erro] = "Área de uso consolidado cadastrada como nativa"
ELSEIF [GRIDCODE] = 2 Then
[Erro] = "Área de vegetação nativa cadastrada como uso consolidado"

End If

Thank you very much!

Najděte více příspěvků označených jako

Accepted answers

EdwinRoa

I'm agree with Daren. You need to store the result in a variable.

Dim value
If [GRIDCODE] = 0 Then
value = "Não há diferença"
ELSEIF [GRIDCODE] = 1 Then
value = "Área de uso consolidado cadastrada como nativa"
ELSEIF [GRIDCODE] = 2 Then
value = "Área de vegetação nativa cadastrada como uso consolidado"

End If

And put into a calculator.

All comments

CarlosPires2

Neil,

version 10.2

sintaxe error

EdwinRoa

I'm agree with Daren. You need to store the result in a variable.

End If

And put into a calculator.

NeilAyres

Sorry Darren, was looking at something else, then you replied....

NeilAyres

In what way doesn't it "work"?

Arc version. Error message etc etc.

Is this something where you are trying to use the field calculator?

DarrenWiens2

You need to store the value in a variable, and use that variable name as the expression:

Expression:

result‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Code block:

If <SPAN class="punctuation token">[</SPAN>GRIDCODE<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> Then
result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Não há diferença"</SPAN>
ELSEIF <SPAN class="punctuation token">[</SPAN>GRIDCODE<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> Then
result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Área de uso consolidado cadastrada como nativa"</SPAN>
ELSEIF <SPAN class="punctuation token">[</SPAN>GRIDCODE<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">2</SPAN> Then
result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Área de vegetação nativa cadastrada como uso consolidado"</SPAN>
End If‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Note: you should always return something with an ELSE.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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