Using the quality bar is a convenient way to filter and remove invalid rows for a given
column, but this action is also available for the whole dataset.
You can apply a filter on all the invalid and empty rows from your dataset to
remove them in a single action.
Let's take the example of a dataset containing customer data, where some phone numbers
and email addresses entries are either invalid or empty.
Procedure
-
Click the menu icon on the top left of the grid.
-
Select Display rows with invalid or empty values.
The filter has been applied and the grid now only displays the rows
containing at least one empty or invalid entries.
You can also choose to only filter the invalid or empty rows to remove them
from your dataset.
-
In the functions panel, search the Delete these Filtered
Rows function and click it to apply it on you data.
The rows have been deleted and you can now remove the filter.
-
In the filter bar, click the cross in the filter or click the garbage bin icon
to display the whole dataset again.
Results
Your dataset is now free of any invalid or empty values and the quality bar is fully
green for all the columns.