Keep or delete filtered rows

Keep or delete filtered rows

You can filter the rows by entering the value based on which the rows should be filtered in the search box in the top bar of the DataPrep Studio page. 

You can also click on the histograph of each column to select the value on which the rows should be filtered.
Some of the other options to filter the data are:
  1. Filter rows with valid values - Only rows with valid data are displayed
  2. Filter rows with invalid values - Only rows with invalid data are displayed
  3. Filter rows with missing values -  Only rows with missing data are displayed
  4. Filter rows with missing or invalid values -  Only rows with missing or invalid data are displayed

To keep or delete filtered rows:

  1. On applying the filters, you can click the option 'Keep Filtered Rows' or 'Delete Filtered Rows' from the data transformation suggestion.
  1. The resultant dataset will be displayed with or without the filtered rows based on the selection.

You can also insert functions to specify the condition to be used in order to filter the rows in the advanced conditions 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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION

                        Still can't find what you're looking for?

                        Write to us:



                          Manage your brands on social media

                              Zoho Marketing Automation

                                Zoho Sheet Resources


                                    Zoho Forms Resources

                                      Secure your business
                                      communication with Zoho Mail

                                      Mail on the move with
                                      Zoho Mail mobile application

                                        Stay on top of your schedule
                                        at all times

                                        Carry your calendar with you
                                        Anytime, anywhere

                                              Zoho Sign Resources

                                                Sign, Paperless!

                                                Sign and send business documents on the go!

                                                Get Started Now

                                                        Zoho TeamInbox Resources

                                                                Zoho DataPrep Resources

                                                                  Zoho DataPrep Demo

                                                                  Get a personalized demo or POC

                                                                  REGISTER NOW

                                                                    Design. Discuss. Deliver.

                                                                    Create visually engaging stories with Zoho Show.

                                                                    Get Started Now

                                                                                          • Related Articles

                                                                                          • Zoho DataPrep Studio

                                                                                            An overview of data preparation in the Studio page is covered in the following sections: Data distribution Data quality Intelligent suggestions Search & filter Topbar The image above displays the Studio page and all the sections associated with it. ...
                                                                                          • Filter

                                                                                            The Advanced filters option allows you to filter data based on custom conditions applied over one or more columns. The advanced filters is exploratory in nature and provides a way to filter your dataset without applying them as a rule. However, you ...
                                                                                          • Deduplicate

                                                                                            You can remove duplicate records from your data using the Deduplicate transform. This can be done in two ways: row-wise and column-wise. Row-wise This method removes rows with duplicate data, allowing only unique rows to be present in your dataset. ...
                                                                                          • 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 ...
                                                                                          • Zoho DataPrep Pricing FAQ

                                                                                            1.1 What are "rows processed"? A row can be defined in the context of a dataset. In simple terms, a dataset consists of rows (records) and columns (fields). Each row in a dataset represents a set of related data and has the same structure. For ...
                                                                                          Wherever you are is as good as
                                                                                          your workplace



                                                                                            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.

                                                                                            CRM Tips

                                                                                            Make the most of Zoho CRM with these useful tips.

                                                                                              Zoho Show Resources