topic Attribute Assistant and Expression Value Method in State & Local Government Questions

Attribute Assistant and Expression Value Method

AlisonGaiser — Tue, 12 Feb 2013 17:42:58 GMT

I am looking for some assistance in setting up the following using the Expression Value Method:

If FieldA is null then
     FieldB & FieldC & FieldA
else
     FieldB & FieldC
endif

Basically I am populating an address field with a concatenation of a number of fields,. If the legal unit is populated I need to add it into the address. If not, I don't want to include it.

I have tried a number of IIF statements but keep getting syntax errors. My latest attempt:

IIF (isNull([UNITID]),("[ADDRNUM] & [QUALIFIER] & " " & [FULLNAME]"),("[ADDRNUM] & [QUALIFIER] & " " & [FULLNAME] &"Unit " & [UNITID]"))

Ther error in the logs is "ERROR: evaluating the expression for feature in GISADM.AD_SiteAddressPoint with OID of 362945 Expected ')'

I am using ArcGIS 10.0 SP3.

Any suggestions are appreciated.

Thanks,
    Alison

Re: Attribute Assistant and Expression Value Method

PaulHiggins — Fri, 22 Feb 2013 18:56:52 GMT

Just a quick observation...your parentheses count doesnt match....thats what the error message is complaining about. You have 3 ( and 4)...try dropping the final ) ... or rexamine your IF syntax as related to number of parentheses...

I am looking for some assistance in setting up the following using the Expression Value Method:

If FieldA is null then
     FieldB & FieldC & FieldA
else
     FieldB & FieldC
endif

Basically I am populating an address field with a concatenation of a number of fields,. If the legal unit is populated I need to add it into the address. If not, I don't want to include it.

I have tried a number of IIF statements but keep getting syntax errors. My latest attempt:

IIF (isNull([UNITID]),("[ADDRNUM] & [QUALIFIER] & " " & [FULLNAME]"),("[ADDRNUM] & [QUALIFIER] & " " & [FULLNAME] &"Unit " & [UNITID]"))

Ther error in the logs is "ERROR: evaluating the expression for feature in GISADM.AD_SiteAddressPoint with OID of 362945 Expected ')'

I am using ArcGIS 10.0 SP3.

Any suggestions are appreciated.

Thanks,
    Alison

Re: Attribute Assistant and Expression Value Method

MikeMillerGIS — Wed, 27 Feb 2013 10:48:22 GMT

Can you try this?

IIF (isNull([UNITID]),([ADDRNUM] & [QUALIFIER] & " " & [FULLNAME]),([ADDRNUM] & [QUALIFIER] & " " & [FULLNAME] & "Unit " & [UNITID]))

Re: Attribute Assistant and Expression Value Method

AlisonGaiser — Wed, 27 Feb 2013 19:06:39 GMT

Thanks Mike. That works perfectly!