topic Re: Inner Join (Keep All Target Features) Symbology Issue in ArcGIS Pro Questions

Inner Join (Keep All Target Features) Symbology Issue

BrianBulla — Mon, 28 Nov 2022 16:50:33 GMT

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!

Re: Inner Join (Keep All Target Features) Symbology Issue

MatthewDriscoll — Mon, 28 Nov 2022 20:57:51 GMT

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.

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

Re: Inner Join (Keep All Target Features) Symbology Issue

BrianBulla — Fri, 02 Dec 2022 13:17:57 GMT

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.

Re: Inner Join (Keep All Target Features) Symbology Issue

MatthewDriscoll — Fri, 02 Dec 2022 14:10:02 GMT

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.

Re: Inner Join (Keep All Target Features) Symbology Issue

BrianBulla — Fri, 02 Dec 2022 14:12:10 GMT

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

Re: Inner Join (Keep All Target Features) Symbology Issue

BrianBulla — Fri, 02 Dec 2022 15:39:56 GMT

Nice! Thanks for the advice.