Inner Join (Keep All Target Features) Symbology Issue

[BrianBulla]

Hi,

So I am joining a table of inspections to a feature layer.  I join the inspections to the features and select "Keep All Target Features", so I can see both the features that have been inspected as well as the ones not inspected.  I use the join field to see where there are NULL values....those are the ones that have NOT been inspected.  Here is an example:

My problem is I need to symbolize based on the FACILITYID field.  So I need one symbol for all the NULL values, and another symbol for all the 'other' (or NOT NULL) value.

How do I do this?  There does not seem to be an obvious way to do this.  When I select to symbolize by Unique Values and select the FACILITYID field, it just starts trying to add all the WCV-### values into the window.  I only need NULL and NOT NULL, not each individual value.

Hopefully that makes sense.

Thanks!

[MatthewDriscoll · Accepted solution]

Symbolize by Unique Values.  Move the NOT NULL values so they are all in a row.  Click the first one -> Shift Click the last one -> Right click the Value or Label of one of those selected -> Group Values.  

OR

Unique Values -> More -> Remove all.  Click the + (Add unlisted values) -> add the NULL.  More -> Show all other values.

[BrianBulla]

Hi,

Yes, I have tried what you are proposing but perhaps this is a unique situation.  The inspection "table" I am talking about is getting updated all the time, so a feature that doesn't show up as inspected today, might actually have an inspection in it the next time around.  I plan on publishing this as a webservice so it needs to be able to by dynamic and just work everytime without manually updating it constantly.

There must be a way to use a "NULL" and "IS NOT NULL" in the symbology of the layer.....right??  Or am I just dreaming.

[MatthewDriscoll]

The second solution I provided should do this.  Symbolize the NULL only and the new features will show up as the all other values symbol no matter what the value is, if not NULL.

[BrianBulla]

Ahh....ok....I see now.  Let me try.

[BrianBulla]

Nice!  Thanks for the advice.