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

Using OR statement i Field Calculator

GjermundDeggerdal

I am using ArcMAP 10.8 and i am trying to add a new field to a table. So far so good..

In this new field i want a number between 1 and 5. The number is decided based on what is written in three other fields in the table ([MATERIAL], [YEAR] and [DIM]) So therefore i am using the Field Calculator. My problem is that i have never gotten the OR statement to work without writing the whole code again.

Therefore I have to write it like this to work:

dim n
if [DIM]=< 100 and [YEAR] =< 1959 and [MATERIAL] = "SJG" or [DIM]=< 100 and [YEAR] =< 1959 and [MATERIAL] = "SJ" then
n = 5

But, I want to write it like this (or something similar);

dim n
if [DIM]=< 100 and [YEAR] =< 1959 and [MATERIAL] = "SJG", "SJ" then
n = 5

I would really appriciate if there is some solution to this problem 😉

Encuentra más publicaciones etiquetadas con

Accepted answers

Jelle_Stu_PR

I would use a python a script by setting the expression type to python.

Expression:

reclass(!DIM!,!YEAR!,!MATERIAL!):

code block:

def reclass(dim, year, material):
    if dim <= 100 and year <= 1959 and material in ("SJG", "SJ"):
        return 5

JayantaPoddar

In Pre-logic Script, it's just a variable name used in the function. In the expression those variable named get replaced by actual Field Names.

In Expression, delete the fieldnames, and add them again by double-clicking the appropriate items in the Fields list, separated by comma.

Also you won't get any result, if the logic is not true for any record.

All comments

Jelle_Stu_PR

I would use a python a script by setting the expression type to python.

Expression:

reclass(!DIM!,!YEAR!,!MATERIAL!):

code block:

def reclass(dim, year, material):
    if dim <= 100 and year <= 1959 and material in ("SJG", "SJ"):
        return 5

JayantaPoddar

This has also worked for me (Parser: Python).

Code Block:

def reclass(dim,year,material):
    if dim<=100 and year<=1959 and material in ("SJG","SJ"):
        return 5

Expression:

reclass( !DIM!, !YEAR!, !MATERIAL! )

GjermundDeggerdal

Thank you very much for your helpfull respons! I am truly sorry if my follow-up questions are stupid and basic, but I`m stuck.

I have probably done something wrong, because I can`t get this command to work. I wrote it in like this (Copy - paste from your post). Is there something more I have to add to the statement?

And I dont understand why you don`t need exclamation marks around the variable inside the pre logic script, this seems diffrent then in VB Script?

JayantaPoddar

In Pre-logic Script, it's just a variable name used in the function. In the expression those variable named get replaced by actual Field Names.

In Expression, delete the fieldnames, and add them again by double-clicking the appropriate items in the Fields list, separated by comma.

Also you won't get any result, if the logic is not true for any record.

GjermundDeggerdal

Thanks, Your code worked perfect with copy-paste, the problem was that i had empty values "Null" and shape did not allow it. I converted it to gdb and it worked right away! Cheers!

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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