Where Expression

[PamFoster]

Hi-

I'm trying to label a field using an expression.

I want the attribute to be labeled with field x except when field x equals "other" than I want it to be labeled with field y.

I don't know how to write the code/expression.

Any help would be appreciated, thanks!

Kait

[JakeSkinner · Accepted solution]

Hi Kaitlyn,

Here is an example on how to do this using the Python parser:

def FindLabel ([FIELDX], [FIELDY] ):
  if  [FIELDX] == 'other':
    return [FIELDY]
  else:
    return [FIELDX]

Below is a screen shot of the Label Expression dialog:

[PamFoster]

Thanks! That worked!