How to update a field with values from another field in table?

808707

Hello,

I have a big dataset with a field of values ranging from 1 to 10.

I want to update another field with a string depending on which value is in the other field.

So for example:

1 = Woodland
2 = Arable
3 = River, etc etc

I was wondering how I would go about this in arcgis?

I have done something similar with SQL using an IIF function but am struggling with how to figure it out.

Thanks for any help

JakeSkinner

Hi Mark,

Here is an example on how to do this using the arcpy.da.UpdateCursor (10.1 or beyond is required):

import arcpy from arcpy import env env.workspace = r"C:\temp\python\test.gdb"  fc = "featureClass"  with arcpy.da.UpdateCursor(fc, ["field1", "field2"]) as cursor:     for row in cursor:         if row[0] == 1:             row[1] = 'Woodland'         if row[0] == 2:             row[1] = 'Arable'         ......             .....         cursor.updateRow(row)  del cursor, row