Filtering Out Empty Values

Datasets on SolveBio are usually populated with clean, processed data. In some cases datasets will be "sparse", meaning that some fields will have a significant number of empty values. This article helps distinguish blank and missing values and explains how to filter them out of datasets.

For most field data types (everything except string and text), empty fields are represented with a "null" value. On the dataset page, open the Filter sidebar, select the field, and choose the condition is not missing, and click Add Filter.



Adding a second filter for empty strings

Some string fields can have empty values that actually contain an empty string (i.e. ""). This means that to truly filter out all empty values you'll need to exclude those as well. To do this, add a second filter on the same field to filter out fields that do not equal "" (empty string), as in the example below:



Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk