nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute Assistant and Expression Value Method

AlisonGaiser

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

Find more posts tagged with

Local

Accepted answers

MikeMillerGIS

Can you try this?

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

All comments

AlisonGaiser

Thanks Mike. That works perfectly!

MikeMillerGIS

Can you try this?

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

PaulHiggins

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.