topic Re: How to update a field with values from another field in table? in Python Questions

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

808707 — Tue, 11 Feb 2014 09:27:24 GMT

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

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

JakeSkinner — Tue, 11 Feb 2014 11:06:59 GMT

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

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

808707 — Sat, 11 Dec 2021 09:21:43 GMT

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

Thankyou very much that worked a treat 🙂