topic Re: Attribute Assistant in Water Utilities Questions

Attribute Assistant

GIS_geek — Mon, 16 Sep 2019 16:26:43 GMT

I am trying to set a condition using Attribute Assistant. I have a feature layer (GPS_Meter) with a field called SYSTEM. The SYSTEM field is populated with Potable, Non-Potable, and Sewer. I am trying to auto populate another field (UID) with either DW, RW, or SS and the OBJECTID. I have the following populated in the DynamicValue table,

Table Name: GPS_Meter

Field Name: UID

Value Method: EXPRESSION

Value Info: IIF([SYSTEM]=Potable, "DW", IIF([SYSTEM]=Non-Potable, "RW", IIF([SYSTEM]=Sewer, "SS"))) & [OBJECTID]

I run AA for selected GPS_Meter points and the UID field does not get populated. Any help will be greatly appreciated.

Re: Attribute Assistant

PaulLeBlanc1 — Mon, 16 Sep 2019 16:57:14 GMT

Is the SYSTEM field text? You'll need to enclose the values in quotes:

IIF([SYSTEM]="Potable", "DW", IIF([SYSTEM]="Non-Potable", "RW", IIF([SYSTEM]="Sewer", "SS"))) & [OBJECTID]

Re: Attribute Assistant

GIS_geek — Tue, 17 Sep 2019 18:41:03 GMT

Paul,

Thanks for the reply. It is a text field. I added the quotes and still getting no results. The UID field does not get populated.

Re: Attribute Assistant

MikeMillerGIS — Tue, 17 Sep 2019 20:39:09 GMT

IIF was monkeypatched in the msscriptcontrol. I believe you need to do & inside it. I have never tested this. The logic may not work and you might need a second expression statement that fires after this one. Which is <The Edited Field> & [OBJECTID]

IIF([SYSTEM]=Potable, "DW" & [OBJECTID], IIF([SYSTEM]=Non-Potable, "RW" & [OBJECTID], IIF([SYSTEM]=Sewer, "SS" & [OBJECTID])))

Re: Attribute Assistant

GIS_geek — Wed, 18 Sep 2019 21:54:46 GMT

Thank you all for your help. I had the last part of the IIF statement incorrect. I removed the IIF([SYSTEM]="Sewer" and it worked. Below is the updated expression

IIF([SYSTEM]="Potable", "DW", IIF([SYSTEM]="Non-Potable", "RW", "SS")) & [OBJECTID]