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?
