How To: Exclude null value features when symbolizing based on a joined field in ArcMap
Instructions provided are for creating a symbology exclusion query that catches null values for joined data created with the default option of 'Keep all records'.
Exclusion is only supported for the following layer symbology options: Graduated colors, Graduated symbols, Proportional symbols, Pie charts, Bar/Column charts, Stacked bar charts, Quantity by category.
Perform the following steps:
- Symbolize the joined data.
- Right-click the layer and click Properties.
- Click the Symbology tab.
- Click Exclude or Exclusion to open the Dialog Exclusion Properties dialog box.
If the data symbolizes Graduated colors or Graduated symbols, click Classify to open the Classification dialog box and then click Exclusion.
- Click the Query tab on the Data Exclusion Properties dialog box.
- Create a query that uses 'Is Null' to return the null value features.
If TableB is joined to FeatureClassA,
this would be a valid query:
(FeatureClassA.OBJECTID is Not Null) and (TableB.fieldB is Null)
The query must contain at least one term that involves a field in the base table. This is necessary to access fields from the joined table. A term that returns all records can be used. For example, FeatureClassA.OBJECTID can be used and doesn't affect the results since it returns all records.
Depending on what type of data you are working with, you may need to modify the above syntax by surrounding each field name with either double quotes or square brackets. For example:
([FeatureClassA.OBJECTID] is Not Null) and ([TableB.fieldB] is Null)
("FeatureClassA.OBJECTID" is Not Null) and ("TableB.fieldB" is Null)