If - Then Statements in Field Calculator

Question

I have a pretty simple set of replace functions I need to complete in an attribute table.  I have a feature class with approximately 135k records with a "MUN" attribute representing the four digit code of the applicable municipality.  I have a new field called "MUNI" in which I wish to populate the correct Municipal name.  There are 12 municipalities.

I've worked on several variations of the code in field calculator but none seem to work; general syntax error.  Coding and languages were never my strong suit so it doesn't necessarily surprise me but nevertheless.  I had a working expression to do just this but it had been deleted.

If [MUN] = 0901 Then
 [MUNI] = Bayonne
ELSEIF [MUN] = 0902 Then
 [MUNI] = East Newark
ELSEIF [MUN] = 0903 Then
 [MUNI] = Guttenberg
ELSEIF [MUN] = 0904 Then
 [MUNI] = Harrison
ELSEFIF [MUN] = 0905 Then
 [MUNI] = Hoboken
ELSEIF [MUN] = 0906 Then
 [MUNI] = Jersey City
ELSEIF [MUN] = 0907 Then
 [MUNI] = Kearny
ELSEIF [MUN]= 0908 Then
 [MUNI] = North Bergen
ELSEIF [MUN] = 0909 Then
 [MUNI] = Secaucus
ELSEIF [MUN] = 0910 Then
 [MUNI] = Union City
ELSEIF [MUN] = 0911 Then
 [MUNI] = Weehawken
ELSEIF [MUN] = 0912 Then
 [MUNI] = West New York

A simple expression I should be able to build with little effort but not having done this for a bit is hanging me up!

Raheel0600 · Answer

In case of

i just need to put only One Name in the output field.

For Example

Case "0901" output = "Bayonne"
Case "0902" output = "East Newark"
Case "0903" output = "Guttenberg"
Case "0904" output = "Harrison"

Case "0805" output = "Hoboken"
Case "0906" output = "Jersey City"
Case "0807" output = "Kearny"
Case "0808" output = "North Bergen"
Case "0809" output = "Secaucus"
In 09 Series i have to put only "Bayone" and in 08 series i have to put only Newyork in this case what should i do.

RichardFairhurst · Answer

Jason's code comes the closest for VB, but you have to close all of the conditions with an End If statement at the end of the code block.

I would use the Select Case syntax instead, since ELSEIF may fail after 7 levels (based on past experience with VBA).  My Code would be:

Parser: VB Script

Use Code Block: Checked

Pre-Logic Code Block:Select Case [MUN]
 Case "0901" output = "Bayonne"
 Case "0902" output = "East Newark"
 Case "0903" output = "Guttenberg"
 Case "0904" output = "Harrison"
 Case "0905" output = "Hoboken"
 Case "0906" output = "Jersey City"
 Case "0907" output = "Kearny"
 Case "0908" output = "North Bergen"
 Case "0909" output = "Secaucus"
 Case "0910" output = "Union City"
 Case "0911" output = "Weehawken"
 Case "0912" output = "West New York"
 Case Else    output = [MUNI]
End Select

Expression (MUNI field)
output

RobertBorchert · Answer

Your making this way to hard.

if you have a the muni code list simply add the table to an ArcGIS Session.  Join the feature to the table muni table via the 4 digit code.  then populate your name field with the name field from the muni table.

Total time to set this up should be less than 2 minutes.  Then depending on your system configuration a little more time to perform the calculation.

If it is a recurring operation MS Access is quick and easy as well.  Have your 4 digit code table in there as a LUT.

Create a query that joins the 2 tables and perform the update with the double click of a query.