🔶Search and filter
Perform search operations and filter data using the Search and filter box. The search and filter box is exploratory in nature and provides a way to filter your dataset without applying them as a rule.
However, you can choose to apply them as a rule by either keeping or deleting the filtered rows.
You can also select one of the default filter options using the filter icon from the Search and filter box:
- Filter rows with valid values
- Filter rows with invalid values
- Filter rows with missing values
- Filter rows with missing or invalid values
If you want to filter data based on custom filter conditions, you can use the Advanced filters option.
👉To search data - To search data, enter the value in the Search and filter box. The searched keyword will be added as a chip below the box based on the default condition ‘contains’.
- You can also select the chip and edit the searched keyword and the condition at any time.
- Once the search result appears, you can choose to Keep filtered rows or Delete filtered rows using the Action dropdown.
👉To filter data - To filter dataset by other means, you can simply click on the histogram, data quality bar, or the donut chart.
- When you filter, a chip appears below the Search and filter box. You can select the chip and edit the searched keyword and the associated condition at any time.
- You can do multiple filters, and a chip would be added for each filter.
- The conditions available in the filter are:
o Contains (default)
o Doesn’t contain
o Starts with
o Doesn’t start with
o Ends with
o Doesn’t end with
o Is
o Is not
o Matches regex - After filtering, you can choose to apply either Keep filtered rows or Delete filtered rows rule using the Actions dropdown that appears next to the chip.
- You can also edit the filters added using the Edit link.
- To remove a particular filter, click the close icon that appears when you hover over the chip.
- To remove all filters at one go, click the Clear link.