Removing all the empty and invalid rows
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.
![](/en-US/data-preparation-user-guide/7.3/Content/Resources/images/removing_all_empty_invalid_1.png)
Procedure
Results
Your dataset is now free of any invalid or empty values and the quality bar is fully green for all the columns.
![](/en-US/data-preparation-user-guide/7.3/Content/Resources/images/removing_all_empty_invalid_4.png)
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!