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.
- Click the white arrow 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.
Your dataset is now free of any invalid or empty values and the quality bar is fully green for all the columns.