Skip to main content
  • EN

Hi all, I have a seemingly easy question. I have two feature classes that I have spatially joined using the spatial relator. There are two cities 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.

One way to do this is to use Conditional values. This can be used in an AttributeCreator or AttributeManager. Create a new attribute called Cities and use a Conditional for the value. When Cities A has a value use Cities A, else when Cities B has a value use Cities B.

2021-01-28_07h19_192021-01-28_07h20_30

One way to do this is to use Conditional values. This can be used in an AttributeCreator or AttributeManager. Create a new attribute called Cities and use a Conditional for the value. When Cities A has a value use Cities A, else when Cities B has a value use Cities B.

2021-01-28_07h19_192021-01-28_07h20_30

Worked like a charm. Many Thanks!

Reply


Community Stats

30,185
Posts
114,569
Replies
37,847
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.