Tip of the Week - Extracting Data from JSON Columns

Tip of the Week - Extracting Data from JSON Columns

Let's say you are importing a CSV or Excel file into Zoho Analytics. What if the file contains a few columns in JSON format? This is where Zoho DataPrep, embedded right within Zoho Analytics, comes in handy. This week's tip explains how to extract data from such files during the initial stages of import easily.


The slideshow below explains the steps of how this can be done.