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

Quick field calculator IF question

TheodoreF

Hi. I have a point FC with 2 text fields. 'Field 1' and 'Field 2'.

I want Field 2 to = 5 IF Field 1 = E

and also

Field 2 to = 4 IF Field 1 = D

So far I've tried this but it returned a syntax error in geoprocessing results:

if [field1] = 'E' then
result = "5"

Could I have any solutions in VB and python if possible? Will help me learn more!

Thanks!

ArcMap 10.5.1

Finde mehr Beiträge mit dem Tag

Accepted answers

jskinner

Hi Theodore,

Using python, you can do this by right-clicking on field 2 > Calculate Field. Check Python at the top and 'Show Code Block'. Enter the following in the first block:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">calc</SPAN><SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="number token">5</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="number token">4</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In the second code block enter:

calc<SPAN class="punctuation token">(</SPAN>!<SPAN class="operator token"><</SPAN>field name<SPAN class="operator token">></SPAN>!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Where <field name> is the name of Field1. When specifying something 'equal to' you will want to use == rather than just =.

All comments

TheodoreF

Due to the amount of Nulls in the fields (which is expected), I can't sum together my 'score' columns (I have a few) into a final 'Total' field. ie. 4 + NULL + 5 = NULL!!!! argh So I'm going to have to edit the original code provided by Jake to return 0 if D or E values aren't found.

EDIT: solution provided above.

TheodoreF

ah sorry:

No, RunS_score is the field I'm trying to calculate. Have I used the wrong field in the final expression box?

DanPatterson_Retired

Ahhh you could have left my code as it was.

I assume that !RunScore! is the field containing the data and not the field you are trying to calculate, it is kindof truncated in your screen grab

TheodoreF

Thanks Dan,

Using your method my codeblock looks like:

def cvt(CLASS_RunS):
    if CLASS_RunS == 'E':
        out = 5
    elif CLASS_RunS == 'D':
        out = 4
    else:
        out = -9
    return out

and my expression is:

cvt( !RunS_score!)

('CLASS_RunS' is the name of Field 1 which contains the Ds and Es. 'RunS_score' is the name of Field 2 where the 4s and 5s are to appear) was I meant to leave this as 'field' like in your reply?

I end up with everything being -9:

Where have I gone wrong?

thanks

TheodoreF

Thanks, works perfectly!

DanPatterson_Retired

Lets not start with question pile on.

For your first question, try

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">cvt</SPAN><SPAN class="punctuation token">(</SPAN>field1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field1 <SPAN class="operator token">==</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out <SPAN class="operator token">=</SPAN> <SPAN class="number token">5</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> field1 <SPAN class="operator token">==</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out <SPAN class="operator token">=</SPAN> <SPAN class="number token">4</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">9</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> out‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In the field calculator, your Field2 needs to be an integer field. That is where you are making the field calculation, so have it active, load the code block with

Parser.... python

expression..... cvt(!Field!)

assuming your field1 is actually called Field1

It can be simplified, but I wanted to emulate your request with the addition of returning a -9 in the first two conditions were not met

jskinner

Hi Theodore,

Using python, you can do this by right-clicking on field 2 > Calculate Field. Check Python at the top and 'Show Code Block'. Enter the following in the first block:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">calc</SPAN><SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="number token">5</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> field <SPAN class="operator token">==</SPAN> <SPAN class="string token">'D'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="number token">4</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In the second code block enter:

calc<SPAN class="punctuation token">(</SPAN>!<SPAN class="operator token"><</SPAN>field name<SPAN class="operator token">></SPAN>!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Where <field name> is the name of Field1. When specifying something 'equal to' you will want to use == rather than just =.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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