topic Re: If statement in Field Calculator in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666926#M22207 <HTML><HEAD></HEAD><BODY><P>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!!</P></BODY></HTML> Tue, 18 Sep 2018 22:03:57 GMT JohannaValente 2018-09-18T22:03:57Z If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666921#M22202 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>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?</SPAN></BODY></HTML> Tue, 07 May 2013 14:25:35 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666921#M22202 GregSullivan1 2013-05-07T14:25:35Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666922#M22203 <HTML><HEAD></HEAD><BODY><SPAN>Hi Greg,</SPAN><BR /><BR /><SPAN>What constitutes the Layer field to have the Minor string, and Major string?&nbsp; If the other field is 1, should the Layer field have a value of 'Minor'??</SPAN></BODY></HTML> Tue, 07 May 2013 16:38:47 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666922#M22203 JakeSkinner 2013-05-07T16:38:47Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666923#M22204 <HTML><HEAD></HEAD><BODY><SPAN>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</SPAN></BODY></HTML> Tue, 07 May 2013 17:06:09 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666923#M22204 GregSullivan1 2013-05-07T17:06:09Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666924#M22205 <HTML><HEAD></HEAD><BODY><SPAN>You can achieve this using python.&nbsp; Here is an example:</SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]24101[/ATTACH]</SPAN></BODY></HTML> Tue, 07 May 2013 17:24:25 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666924#M22205 JakeSkinner 2013-05-07T17:24:25Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666925#M22206 <HTML><HEAD></HEAD><BODY><SPAN>In VB Script you would do the following:</SPAN><BR /><BR /><SPAN>Parser: VB Script</SPAN><BR /><BR /><SPAN>Use Codeblock: checked</SPAN><BR /><BR /><SPAN>Codeblock:</SPAN><BR /><PRE class="lia-code-sample line-numbers language-none">If [Other_Field] = 1 Then &nbsp; Output = "Minor" ElseIf [Other_Field] = 2 Then &nbsp; Output = "Major" Else &nbsp; Output = [Layer] '&nbsp; Use the existing value of the field being calculated so that it won't change. End If</PRE><BR /><BR /><SPAN>expression: Output</SPAN></BODY></HTML> Sun, 12 Dec 2021 04:11:31 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666925#M22206 RichardFairhurst 2021-12-12T04:11:31Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666926#M22207 <HTML><HEAD></HEAD><BODY><P>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!!</P></BODY></HTML> Tue, 18 Sep 2018 22:03:57 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666926#M22207 JohannaValente 2018-09-18T22:03:57Z Re: If statement in Field Calculator https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666927#M22208 <HTML><HEAD></HEAD><BODY><P>Johanna:</P><P></P><P>I am glad it helped.</P></BODY></HTML> Wed, 19 Sep 2018 14:12:12 GMT https://community.esri.com/t5/geoprocessing-questions/if-statement-in-field-calculator/m-p/666927#M22208 RichardFairhurst 2018-09-19T14:12:12Z