Is This Content Helpful?
We're glad to know this article was helpful.
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:
If the data symbolizes Graduated colors or Graduated symbols, click Classify to open the Classification dialog box and then click Exclusion.
(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)