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

Vind meer berichten getagd met

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Inloggen
Registreren

Snelle Links

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