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:
- Extract from List
- 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 Transform panel select an option under the Convert list items to section.
3. If you have selected Columns , enter the index of the items in the list to be extracted into columns.
4. If you have selected the Rows option under Convert list items to section, you can directly convert the array items in the list to rows in the new column.
5. Click Apply .
To extract data from a Map
1. Right-click the Map column and select the Extract from Map option.
2. In the Transform 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.
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.
SEE ALSO
Access your files securely from anywhere
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:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
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 ...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 time
DataPrep provides various options to extract part of time values into a new column. The portions which can be extracted are: Hours Minutes Seconds Milliseconds Period (AM/PM) Timezone Offset To extract part of a time 1. Right-click the time column ...Keyword extraction
You can extract keywords from a selected text column using the Keyword extraction operation powered by AI and machine learning in DataPrep. For example, if the text column has the value, "DataPrep is powered by Artificial Intelligence", the Keyword ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources