I have a
feature layer in a
gdb. It has an attribute named
uniqueid. Some of rows have a value for
uniqueid and some do not. I am trying to select only the features that have a value (are not blank).
Select by Attributes dialog box, I am trying to create an expression that will weed out the blank features. I tried using
where: unique IS NOT NULL but that selected everything, both the features with a value and those that were blank. I then tried using
Get Unique Values and chose '', which was one of the options. It through an error. What am I doing wrong here? How can I select just the features that have a value for the
uniqueid attribute field?
Here's the actual text version of the error as requested:
There was a problem selecting
An invalid SQL statement was used. An invalid SQL statement was used.[fottprint_cslf_union_20181004] An invalid SQL statement was used.[SELECT OBJECTID FROM footprint_cslf_union_20181004 WHERE uniqueid IS NOT '']