Extract from List and Map

Extract from List and Map


DataPrep supports map and list data types. A Map is also known as the Object data type and the List is also known as an Array.

DataPrep offers extraction of data from the list and map columns using the options:
  1. Extract from List
  2. Extract from Map

To extract data from a List

1. Right-click the List column and select the option Extract from List option. 

2. In the Operations panel select an option under the Convert list items.

3. If you have selected Columns, select the index of the items in the list to be extracted into columns. 

4. You can choose to remove the selected items in the indexes from the source column using the Remove selected items from the source column option.

5. You can also choose to remove the source column using the Remove source column option. This will take effect upon applying the operation.


















6. If you have selected the Rows option under Convert list items section, you can directly convert the array items in the list to rows in the new column. 

7. You can choose to remove the source column using the Remove source column option. This will take effect upon applying the transform.

8. Click Apply



To extract data from a Map:

1. Right-click the Map column and select the Extract from Map option. 

2. In the Operations panel select the keys that need to be extracted into columns. 

3. Enter the column names against the keys, so that the values of each key is mapped to the respective column. 
  1. You can choose to remove the selected keys from the source column using the Remove selected items from the source column option.
  2. You can also choose to remove the source column using the Remove source column option. This will take effect upon applying the transform. 
4. Click Apply






















Note: You can use these operations repeatedly to deal with JSON data that has nested data structures, such as a list of maps or list of lists.


    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

                                                        • Extract from text

                                                          Zoho DataPrep offers options to identify and extract a subset of the data from a column. You can extract very specific portions of the column data using the extract transform. For example, your column contains a mixture of letters and numbers, but ...
                                                        • 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 ...
                                                        • Smart selection

                                                          Zoho DataPrep offers you an array of suggestions using the pattern matching notations when you select portions of the column data that you wish to transform.  Note: If you are not familiar with pattern matching in DataPrep, read about it here. You ...
                                                        • Functions available to add formula columns

                                                          Abs abs(num) Returns the absolute value of the numeric value. Parameters Name Description num Decimal Parameter must be a numeric value from a column or an expression that returns a number. Example Function Result abs(-1) 1 Div ...
                                                        • Pivot

                                                          Pivot Table distributes data for easy consumption. It spreads out the data in long, winding tables by converting categories into columns. A pivot can be created by selecting the Column, Row, and Data fields.  To apply the pivot transform: 1. Click ...

                                                        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