AnsweredAssumed Answered

Update Field from Multiple Field(s)

Question asked by ModernGIS on Sep 19, 2016
Latest reply on Sep 22, 2016 by curtvprice

I have been looking around the internet all morning to figure out how to write a Python script to accomplish what I need to do, and so far, I am not finding what I need. Need to see if someone can start me in the correct direction.

I have (2) text fields:

   ACALARA TYPE and ACALARA MODEL with coded meter type attributes

Another field:

   ACALARA METER TYPE will hold the actual Meter Type 

The data in the first two fields is held in a different database and I have a Python script built that will take that data and update these Feature Class Fields. 

 

What I need to do is build a second python script that is composed of an if/else statement.

EXAMPLE:

   If ACALARA TYPE = 75 and ACALARA MODEL = 130

      Then the ACALARA METER TYPE field will update to show "CEN3S4S20"

   If ACALARA TYPE = 109 and ACALARA MODEL = 2

      Then the ACALARA METER TYPE field will update to show "UMT2.1"

There are around 2 dozen other combinations with additional Meter Type outputs that I will have to include

 

Figuring out how to write this code will help with other Feature Classes that I have been updating manually.

 

Thank You 

Outcomes