I have two feature classes that I have spatially joined using the spatial relator. There are two city fields in this new feature. For the sake of the example, we can refer to them as Cities A and Cities B. Some values are null in both fields, however the Cities A is more accurate.

How do I combine Cities A and Cities B into a new field with priority given to Cities A, assuming it is not null. i.e. if Cities A is null and Cities B has a value, we use Cities B. If Cities A and B both have values for a feature, then only Cities A would be used.

  • 2
    If my answer helped you, please accept it as the answer to the post. Thanks!
    – John
    Commented Jan 28, 2021 at 16:00

1 Answer 1


In FME that process you are speaking of is actually easier to imagine in the sense of a conditional value rather than a weighted value. The easiest way to accomplish this is through the attribute manager, let me show you.

Given this table:

enter image description here

We use an attribute manager with a conditional statement to create and populate the third field, resulting in this output:

enter image description here

Screenshot of how to access Conditional Value Dialogue Box: enter image description here

Screenshot of conditional statement: enter image description here

  • 1
    Worked like a charm. Many Thanks!
    – A. S.
    Commented Jan 28, 2021 at 19:23
  • 1
    Glad I could help!
    – John
    Commented Jan 28, 2021 at 20:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.