topic Re: SELECT 'NULL' on a joined table in ArcMap Questions

SELECT 'NULL' on a joined table

nimitz — Tue, 14 May 2024 23:44:01 GMT

Hi all, I have joined a sde feature class to a .txt. The .txt file has several hundred 'NULL' values in the field I want to select from. However, I want to select NON-NULL values. ArcMap won't let me select NULLs. After that I would want to flip the selection set to show every record that has a value.

WINDOWS 10, acrmap 10.8.2

Thx

Re: SELECT 'NULL' on a joined table

JeffHouser — Wed, 15 May 2024 01:30:08 GMT

Nimitz,

In ArcMap, Selection - Select Attributes, cant you use "field" is not null to select features with non-null values?

~Jeff

Re: SELECT 'NULL' on a joined table

nimitz — Wed, 15 May 2024 15:51:02 GMT

Dooood!! You 'da man!!😀 Worked like a charm! Now, if I could automate this process...

I owe you a beer!

Re: SELECT 'NULL' on a joined table

RhettZufelt — Thu, 16 May 2024 23:05:01 GMT

You can if you want to use python.

Add Join.

Select by Attributes.