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?
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.
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.
Is there any possibility that i can use IF condition in field calculation?
Click on Get Unique Values and select the blank value from there.
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.
Thanks, I done it
It seems that we have a problem in using IF condition either through VB or by Python
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
