Filter
How to search and filter data?
Filter column
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
Search a specific value
- 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 or Delete the filtered rows. If you want to filter data based on custom filter conditions, you can click the
Advanced
link.
Other means to filter your dataset
-
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 add multiple filters, and a chip would be added for each filter. To add conditions to the filters, click the Advanced link.
To apply filters
-
The All columns filter will apply the filter depending on the values available in all the columns in your dataset.
-
The Any column filter will apply the filter depending on the value available in at least one of the columns in your dataset.
6. Using the logical operators, you can combine the conditions and apply logic to determine the rule of precedence . The final expression is displayed in the Criteria expression box. You can click Edit to alter the default expression using logical operators and parenthesis to specify the precedence or the sequential order as to which condition should be evaluated first . Click Save after making the required changes.
7. You can use the
Clear
button to remove all the filters.
8. For every
filter added, you can select
one
of the following options from the drop-down:
-
Actual:
This option lets you filter rows based on the actual values in the column.
-
Data quality:
This option lets you filter rows based on the quality of data in the column.
-
Patterns:
This option helps you filter rows based on the data patterns in the selected column.
- Seasonal: This option helps you filter rows based on the seasonal parameters such as quarter, month, week, etc.
-
Outliers:
This option allows you to filter rows based on the outliers present in the data of the selected column.
Filter Options
Actual
1. Individual values
2. Range
3. Wildcard
-
Contains
-
Doesn't contain
-
Begins with
-
Doesn't begin with
-
Ends with
-
Doesn't end with
-
Is
-
Is not
-
Matches regex
Seasonal
-
Quarter
-
Month
-
Week
-
Weekday
-
Day of the month
Data quality
Patterns
Outliers
7. In the final step, in the selection box, you can
choose to
include or exclude the values selected in the filter values section
using the
Include items
or
Exclude items
option.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Dataset transforms
Dataset transform consists of combining and transforming datasets to suit your needs. You can apply the following transforms in a dataset. Deduplicate Row-wise Column-wise Join Append Pivot Unpivot Calculated columns Derive dataset Mark as personal ...Derive dataset
The Derive dataset transform allows you to create a branch of your dataset from the last applied transform in your dataset. The new dataset will have the most recent state of your data with an empty ruleset. To derive dataset 1. Click the Transform ...Target Matching
Target matching allows you to set a target and align the source dataset to match with your target before exporting data. You can attach a target dataset to match the column structure, formats, and the data types in the existing source dataset. This ...Window functions to add formula columns
A window function is used to perform calculations across a group of rows on a dataset. A set of rows is termed a window. You can use window functions to perform summations and calculations based on a rolling window of data, relative to the current ...Add formula
You can create new columns and customize them using the Formula column transform. Zoho DataPrep offers a variety of functions to suit your needs. Click here to know more about the functions. To create a formula column 1. Click on the Transform menu ...