Filter
To apply the filter transform
1. Click the Transform menu and select the Filter option. The Filter pane will slide open to view.
2. Choose any of the following options in the Filter options section:
Keep filtered rows - Choosing this option will keep you only the rows that are filtered in your dataset.
Delete filtered rows - Choosing this option will delete all the filtered rows and keep the rest in your dataset.
-
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.
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
Starts with
Doesn't start 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
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 ...