nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SELECT 'NULL' on a joined table

nimitz

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

Finde mehr Beiträge mit dem Tag

Desktop

Accepted answers

JeffHouser

Nimitz,

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

~Jeff

All comments

rzufelt

You can if you want to use python.

Add Join.

Select by Attributes.

nimitz

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

I owe you a beer!

JeffHouser

Nimitz,

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

~Jeff

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.