Select to view content in your preferred language

Null should be visually different from '<Null>' in attribute table

691
4
02-14-2023 12:13 PM
Status: Under Consideration
Labels (1)
Bud
by
Honored Contributor

ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB:

In the attribute table:

The value in the first row for TEST_FIELD equals '<Null>'. The value in the second row is a true null.

Bud_0-1676405272514.png

We can't tell from looking at the attribute table that the two values are different. The only way determine if a value is one or the other is to query it using Select By Attributes, etc.

Idea: It would be very helpful if we could visually discern the difference between null and  '<Null>' right in the attribute table.

Thanks.

 

Related Ideas:

 

4 Comments
DuncanHornby

Sounds like conditional formatting that you get in Excel? I think if it was limited to just colouring up Nulls that would be OK but colouring up other values feels like overkill. Good idea though.

Bud
by

@DuncanHornby For true nulls, the text could be italicized, a lighter grey color, or something like that.

JoshuaBixby

QGIS handles the same situation by having actual NULL italicized and light-grey.

QGIS_null.PNG

 

SSWoodward
Status changed to: Under Consideration

Thanks for the Idea, @Bud. We think this is an Idea worth considering and one of our teams is taking a look at it in more detail.  I've relabeled this with the editing label for better placement and moved it to Under Consideration.

Thanks for all your efforts on the Ideas Exchanges.