Attribute Assistant: IIF and IsNull syntax

DarrenLacina1 — Wed, 18 Jul 2018 20:29:58 GMT

IIF and IsNull...have reviewed a number of posts here but I am having issues getting my scripting to work. I am trying to build a rule to populate a Name field based on values in one of a number of other fields, if there are non-null values in one of the other fields.

For the first test I am including one IIF statement. If PARCELID is not null, I want to populate the Name field with it's value. Here is the syntax that is not working:

IIF(IsNull([PARCELID]),Nothing,[PARCELID])

Here is the info from the AA log:

Row Info
Row Number 2
TableName: ParcelFabric_Parcels
FieldName: Name
ValueInfo: IIF(IsNull([PARCELID]),Nothing,[PARCELID])
ValueMethod: FIELD
On Create: 0
On Change: 0

Checking for Subtype Restriction
Field Name: Name was found at index: 3
Trying: Field
IIF(IsNull([PARCELID]),Nothing,[PARCELID]) is not found
Finished: Field

Instead of Nothing in the scripting, I have also tried Null and "<Null>".

I am using ArcGIS 10.4.1, SQL Server 2014, Attribute Assistant 2017.3.1

Any suggestions?

Re: Attribute Assistant: IIF and IsNull syntax

DarrenLacina1 — Tue, 07 Aug 2018 14:47:01 GMT

Got some help from ESRI Support on this one...just needed to change the value method from FIELD to EXPRESSION and got the scripting to work.

topic Re: Attribute Assistant: IIF and IsNull syntax in State & Local Government Questions

Attribute Assistant: IIF and IsNull syntax

Re: Attribute Assistant: IIF and IsNull syntax