I am building a comparison analysis for a database outside of my GDB, but still use the data within the GDB. I have imported the data into a File GDB and have the following fields I am working with:
Here is what I am doing:
If ACLARA_TYPE = 39 and ACLARA_MODEL = 2 AND EQUALS METER_TYPE = CMT_GEN, then to populate the ANALYSIS_FLAG Field with 1. If it DOES NOT match, then the ANALYSIS_FLAG Field would be populated with 0. Basically, If the METER_TYPE Equals something different (Lets say CMT_1), there is something wrong with the data. The thing is, I am trying to find incorrect METER_TYPE(s) based on the TYPE and MODEL.
ACLARA_TYPE ACLARA_MODEL METER_TYPE ANALYSIS_FLAG
39 2 CMT_GEN 1
39 2 CMT_1 0
I Hope this makes sense on what I am trying to accomplish.
I am using the CALCULATE_FIELD Tool and will eventually build this process into a Python Script.