If/Else Statement Field Calculator

enterprisemaps-gwest

I would like to add a simple if statement to an existing expression, but am having difficulties getting it to execute.  My previous expression in vb script concatenates a number of fields to make one long string in a new field.  I would like to add multiple if else statements to be a part of this expression.

'Trim([NUMBERCYLA]) & ",SB,"& Trim([RESOLUTION_CODE]) & ",,,SC Truck,"& Trim([last_edited_user])& ",Driver,"& Month( [last_edited_date])&"/"& Day([last_edited_date])&"/"& Year ( [last_edited_date]) & ","'

I have a field SCCatDesc that contains the attributes MAT, MBE, MBI, MBW, SBE, and SBI.

If SCCatDesc = MAT then output = SB

If SCCatDesc =  MBE then output = ME

If SCCatDesc =  MBI then output = MB

If SCCatDesc =  MBW then output = MW

If SCCatDesc =  SBE then output = SB

If SCCatDesc =  SBI then output = SBI

I have tried the following as start however it does not work.

1. If [SCCatDesc] = "MAT" Then 
2.   Output = "SB" 
3. ElseIf [SCCatDesc] = "MBE" Then 
4.   Output = "ME" 
5. Else 
6.   Output = "TEST"
7. End If 

import arcpy

#Define Local Parameters
whereclause = "PlannedDate = CONVERT(DATE, GETDATE())"
SDEFeatureClass = "C:\Users\Administrator\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Connection to localhost_SCData_sa.sde\SCData.DBO.SO_SC"
LocalFGDB = "C:\PeterText.gdb"
Outable = "WLATable"
PeterTable = "C:\PeterText.gdb\WLATABLE"
expression = 'Trim([NUMBERCYLA]) & ",SB,"& Trim([RESOLUTION_CODE]) & ",,,SC Truck,"& Trim([last_edited_user])& ",Driver,"& Month( [last_edited_date])&"/"& Day([last_edited_date])&"/"& Year ( [last_edited_date]) & ","'

#Selection Query
selection = """CYLA_DISTRICT = 'WLA' AND PlannedDate = CONVERT(DATE, GETDATE())"""







#Deletes old FC
if arcpy.Exists(PeterTable):
  arcpy.Delete_management(PeterTable)


#Sends Feature Class to Table with Where Clause
arcpy.TableToTable_conversion(SDEFeatureClass, LocalFGDB, Outable, selection)

#Calculates Field with expression for Peter Text File
arcpy.CalculateField_management(PeterTable, "PtrText", expression)










#Search Cursor to extract Peter Text Field
myOutputFile = open("C:\PeterScripts\WLA\Peter.txt", 'w')
rows = arcpy.da.SearchCursor("C:\PeterText.gdb\WLATable", ["PtrText"])
for row in rows:
  myOutputFile.write(str(row[0]) + '\n')
del row, rows
myOutputFile.close()

XanderBakker

In addition to what Blake indicates, you could use a dictionary (key, value pairs) to hold the values you want to recode. In python this would be something like:

dct = {"MAT": "SB",  "MBE": "ME",
      "MBI": "MB", "MBW": "MW",
      "SBE": "SB", "SBI": "SBI"}

SCCatDesc = "MBI"
output = dct[SCCatDesc] if SCCatDesc in dct else "TEST"

...will result "MB"

With respect to the other expression you could do this in python:

from datetime import datetime
last_edited_date = datetime.now()
NUMBERCYLA = "NUMBERCYLA"
RESOLUTION_CODE = "RESOLUTION_CODE"
last_edited_user = "last_edited_user"
datetxt = last_edited_date.strftime("%m/%d/%Y")

result = "{0},SB,{1},,,SC Truck,{2},Driver,{3},".format(NUMBERCYLA, RESOLUTION_CODE, last_edited_user, datetxt)
print result

will yield:

>> NUMBERCYLA,SB,RESOLUTION_CODE,,,SC Truck,last_edited_user,Driver,02/03/2015,

I would probably use an arc.da.UpdateCursor to update the information...