topic Re: Adding Null value symbology? in ArcGIS Pro Questions

Adding Null value symbology?

AndreasB — Thu, 19 Sep 2024 15:06:23 GMT

Hi,

I have a symbology which is set through two attributes using unique values.

For example the values would be
800,100
801,100

in my database there is a combination of this two fields with a <Null> value
For example: 800; <Null> and this is picked up in the symbology when I do, add all values

Now I also want to add 801; <Null> to this symbology posibilities, now this combination is not present yet in the attribute table but could be in the future.

Yet when I try to do this via the "add values" option in the symbology pane I always get an error:

I tried several different options of null, " ", , Null, <Null> but nothing works
The field from the <Null> is a numeric long integer field. How can I add this to the list??

Re: Adding Null value symbology?

Ed_ — Thu, 19 Sep 2024 15:40:35 GMT

Maybe change the Null column to text then
right click on the Value (data type text) column and open the "Calculate Field" tool
select Arcade or Python whatever works for you
apply the symbology again
For testing purposes I created a dummy table where Value1 is long and Value4 is text so I manually typed in <Null>

Re: Adding Null value symbology?

DavidSolari — Thu, 19 Sep 2024 16:22:21 GMT

Make a copy of the feature class, ensure it has the same symbology as the source layer, add records which contain the values you want to symbolize, add those options to the unique values, configure the symbols, save this to a layer file, apply this layer file to the source layer, delete the copy. Boom, you're ready for future data without tampering with the production features!

Re: Adding Null value symbology?

clt_cabq — Thu, 19 Sep 2024 18:59:48 GMT

Does using the term Nothing instead of Null work? In calculations where you want to make a field's value null you use an expression like 'FieldName = Nothing' so this makes me wonder if that will work here.

Re: Adding Null value symbology?

AndreasB — Fri, 20 Sep 2024 08:13:46 GMT

Nothing didn't work unfortunatly.

I'm currently working with map services that are read only so I can't temper with the data.

I mainly to know why it does get taken into account when it's in the attribute table but when the combination is not and you want to add it you get a warning that this value is not allowed.