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

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.