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 statement in Field Calculator

GregSullivan1

Hello,

I am having problems with if statements in the Field calculator. This is my first time trying to code something in the field calculator. I am familiar with coding as I have used java and visual basic before. I created contours and I have a field that is set to 1 for all contours that are not an interval of 5 and set to 2 for all 5 foot contours. I have created another Field called Layer that I want to populate with a string for Minor and a different string for major contours. Can anyone help with this?

Vind meer berichten getagd met

Accepted answers

jskinner

You can achieve this using python. Here is an example:

[ATTACH=CONFIG]24101[/ATTACH]

screen.png

All comments

RichardFairhurst

Johanna:

I am glad it helped.

joeyvalente

I've been on a 2 hour search for the right code to do my basic If/Then Statement and yours was the only one that worked, thank you!!

RichardFairhurst

In VB Script you would do the following:

Parser: VB Script

Use Codeblock: checked

Codeblock:

If [Other_Field] = 1 Then
  Output = "Minor"
ElseIf [Other_Field] = 2 Then
  Output = "Major"
Else
  Output = [Layer] '  Use the existing value of the field being calculated so that it won't change.
End If

expression: Output

jskinner

You can achieve this using python. Here is an example:

[ATTACH=CONFIG]24101[/ATTACH]

screen.png

GregSullivan1

Yes I am trying to set the Layer field to 'Minor' if the other field = 1 and set the layer field to 'Major' if the other field = 2

jskinner

Hi Greg,

What constitutes the Layer field to have the Minor string, and Major string? If the other field is 1, should the Layer field have a value of 'Minor'??

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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