Click the Transform menu and select the Filter option. The Filter pane will slide open to view.
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.
Click the icon to add columns to the filters. The All columns filter is added by default. However, you can add more filters or remove the existing ones. You can also reorder the filters using the drag and drop method.
When you add more than one filter to the Filters section, the logical operators, AND or OR appear next to the filters. You can click to toggle the logical operator between AND and OR.
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.
You can use the Clear button to remove all the filters.
For every filter added, you can select one of the following options from the drop-down:
Individual values: You can select the required individual values from here. You can also search for values using the Search bar. Click the +Add new data button to add new individual values.
Range: If you choose the Range option, you can select the required range of values. Create your own range using the +Add new range button.
Wildcard- If you choose the wildcard option, you can construct the required condition using the String or expression field. Click the icon to add more conditions.
When you add more than one condition in the Wildcard tab, the logical operators, AND or OR appear next to the conditions. You can click to toggle the logical operator between AND and OR.
Day of the month
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 .
Click the Preview button to view the preview of the filter in the Preview pane.
Click the Apply button to apply the filter transform.
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.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.
Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.
Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.
Make the most of Zoho CRM with these useful tips.