Filter
Advanced filters
How to search and filter data?
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.
Filter data
- 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 Advanced 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.
4. 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.
5. You can use the Clear button to remove all the filters.
6. 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.
8. Click the Preview button to view the preview of the filter in the Preview pane.
9. Click the Apply button to apply the filter transform.
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:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
|
Quick Links |
Workflow Automation |
Data Collection |
|
|
||
|
Form Templates |
||
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 ...Append
In DataPrep, you can append one dataset with another and create a new dataset using the Append transform. Here's a quick video on how to use the Append transform. To append datasets 1. Click the Transform menu, click Combine , then select Append . 2. ...Join
You can join two datasets together using common columns using the Join transform. For example, consider a dataset which has the purchase data of a store and another dataset with their customer information. These datasets can be combined using a ...