topic Re: I am not able to use IF condition in filed calculator ? in Developers Questions

I am not able to use IF condition in filed calculator ?

ArpitSingh — Fri, 17 Mar 2017 05:48:58 GMT

Here I have created a new field named GS which has values from the field V_type but there are some missing values in field V_type so i want to fill the GS filed with another field named Location

How should i proceed with this?

Re: I am not able to use IF condition in filed calculator ?

JayantaPoddar — Fri, 17 Mar 2017 06:25:24 GMT

What you think about the following steps:

1. Use Select by Attributes: where V_Type = " " (Choose the blank value/values from the list of unique values).

2. Once the records are selected, populate the GS field with the values of the alternate field using field calculator.

Re: I am not able to use IF condition in filed calculator ?

ArpitSingh — Fri, 17 Mar 2017 07:15:49 GMT

Is there any possibility that i can use IF condition in field calculation?

Re: I am not able to use IF condition in filed calculator ?

JayantaPoddar — Fri, 17 Mar 2017 07:55:16 GMT

Click on Get Unique Values and select the blank value from there.

Re: I am not able to use IF condition in filed calculator ?

DanPatterson_Retired — Fri, 17 Mar 2017 07:57:57 GMT

You didn't press the Get Unique values button, otherwise there would be a list of unique values listed. That whole expression can be created without typing and the " " should be in single quotes ' ' if you had selected from the unique values. Also, you need to press the Verify button to verify the expression, it sometimes yields better error messages.

Re: I am not able to use IF condition in filed calculator ?

ArpitSingh — Fri, 17 Mar 2017 08:28:46 GMT

Thanks, I done it

It seems that we have a problem in using IF condition either through VB or by Python

Re: I am not able to use IF condition in filed calculator ?

DanPatterson_Retired — Fri, 17 Mar 2017 08:52:36 GMT

Where is the 'if' statement? Are you using this as an example for an outside program? If so and those blanks cells weren't spaces, then they would have been represented as such ( '' ) whereas in a geodatabase I would have expected to see a null representation. There are ways to check for these conditions with if statements if you are using python in a separately called program

Re: I am not able to use IF condition in filed calculator ?

ArpitSingh — Fri, 17 Mar 2017 11:58:03 GMT

Since I am using the shape file which has been created by some other person , due to some technical reasons while making of the shape file he has put some blanks in V_type field (as you can it in first picture). Now I created a new field (GS) which has the values same as V_type and where there is blank in V_type I was trying to put the value from Location field, So In the field calculation I was trying to use the If condition

General logic for If condition was

new field(GS) = V_type if V_type is blank/Null then GS = Location

I was trying to use this logic in field calculation which seems to be not possible.

Re: I am not able to use IF condition in filed calculator ?

DanPatterson_Retired — Fri, 17 Mar 2017 13:21:25 GMT

since this was a on-off, the easiest way is to do a quick select-by-attributes to get the records that are 'empty', then use the field calculator with newfield=oldfield because the field calculator only works on selected records rather all records. This saves you the hastle of trying to come up with a field calculation function that accounts for 1 space, no spaces, non-printable characters etc.