Context menu

Context menu

Zoho DataPrep offers various options in the context menu to perform column level operations. 

A few basic options here are Sort, Rename, Delete and Move.

To access the context menu, right click the column name and click any one of the icons to perform the necessary operation on the column.



Sort

1. You can sort the column values in either Ascending or Descending order.

2. Right click the column name and click the respective sort icon. The column data gets sorted in the chosen order.

Rename

1. You can change the name of a column using the Rename option. 

2. Right click the column name and click Rename.
 
3. Enter the new name you want to assign in the New name box in the Operations bar and click the Apply button to apply the change. 

You can also choose to rename multiple columns by clicking the + button near the New name box.



Delete

1. Any column in the dataset can be deleted by using the Delete icon from the context menu.

2. Click the delete icon and select the column to be deleted from the 'Select columns to delete' box and click Apply.

You can delete multiple columns by clicking the + button on the Operations bar, selecting the necessary columns to be deleted and then clicking Apply.



Move 

1. The context menu also includes move, using which you can move any column and edit the order of the columns in the dataset.

2. Click move from the options and select the column to be moved.

3. Then, select which position and column near which the selected column is to be moved to and click Apply.



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

                Zoho SalesIQ Resources



                    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

                                                        • Duplicate Column

                                                          Zoho DataPrep allows you to duplicate columns present in your dataset. To duplicate columns 1. Right-click on a column header and select the Duplicate columns option from the context menu. 2. Select the columns from the Columns to duplicate dropdown. ...
                                                        • Extract from date

                                                          DataPrep provides various options to extract part of date values into a new column. The portions which can be extracted are: Year Quarter and year Month and year Week and year Date Time Quarter Month Week Day of the week Day of the month To extract ...
                                                        • Convert units

                                                          DataPrep offers special operations to meet unique requirements with transforming data. For example, if you need to share your dataset with different regions which use different standards of measurements, you can use the Convert units special ...
                                                        • Sentiment analysis

                                                          You can analyze the sentiment of the text values in a column using the Sentiment analysis operation powered by AI and machine learning in DataPrep.   There are three possible results from the sentiment analysis transform. Positive Negative N/A (i.e., ...
                                                        • Split

                                                          DataPrep allows you to split the columns based on the given input. A column can be split into multiple columns using a delimiter based on the chosen split option. You can divide a column into multiple columns using the Split transform.  To split a ...

                                                        Resources

                                                        Videos

                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                        eBooks

                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                        Webinars

                                                        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