Where is "Get Unique Values" in Pro?

[JacobGeisler]

Good morning,

In map, when selecting attributes, there was a "get unique values" button you could use to see all attributes that were applicable to a field. Our organization would do QA/QC on a field by using this button to check and make sure there were no extra attributes that were accidently entered.  For example, we have a field labeled "notes" that we only use if applicable to an address point.  If not, we calculate an open string and do not leave it as null.  This is where the issue is arising as in map, it would differentiate between an open string ("") or just a space (" ").  Now, there is no way to differentiate.  When selecting attributes in PRO, it only shows one on the drop down as blank and we don't know if it is the open field or the space.  Hopefully this makes sense.  Is there a "get unique values" button in Pro I am missing?  Or is there a work around to this?

[DanPatterson]

there is one in editing

Edit feature attributes—ArcGIS Pro | Documentation

Type attribute values for new features—ArcGIS Pro | Documentation

Alternatively, right-click the field and choose one of the following commands:

Get Unique Values

I don't remember one for select by attributes

Choose a value currently stored in this field.

[JenniferCadkin]

The Attributes pane and Editing Templates attribute grids have Get Unique Values functionality.  Right click on the attribute and choose Get Unique Values.  Then click in the cell to access the dropdown.

[JacobGeisler]

This helps but the drop down does not differentiate between an open string vs a space.  That is the main issue.  In map, there would be two values, one that showed "" and the other would show " ".  But in Pro, open string and space are shown as one value.  So there is no way to know if someone calculated an open string or just hit space and if someone hit space that is wrong but we would not be able to catch that during our QA/QC process.

[Cheryl]

I'm just getting my feet wet with Pro (and having so much fun) and that's the only way I've found, too. I had an issue yesterday where I had what looked like two empty fields in the dropdown, and couldn't tell if one was one space, the other two spaces or what. Wish it was a bit simpler, too.

[JacobGeisler]

Yes, and it was like that in map so I am not sure why in Pro they don't show both.  They only show one unique value that doesn't differentiate between the open string and someone just putting a space.

[JayCary · Accepted solution]

The Regular Expression or Query Attributes check in ArcGIS Data Reviewer (using the Run Data Check command) can be used to find string fields that contain only " " values.

An attribute filter can also be applied to evaluate a subset of the features in the layer.

[JacobGeisler · Accepted solution]

Thank you,  I will try this out and see if it works.