We will discuss the following sections in this documentation:
The process of importing data into an existing table in Zoho Analytics is similar to steps followed while importing data to create a new table.
You can import data stored in local drives in various tabular formats into existing tables in Zoho Analytics with ease. To learn more about importing data from files, and the various file types that are supported, refer this documentation.
You can also import data stored in web URLs into existing tables in Zoho Analytics with ease. To learn more about importing data from web URLs, and the various file types that are supported, refer this documentation.
Zoho Analytics allows you to import varied data stored in different cloud drives/storages like Google Drive, Dropbox, OneDrive, etc., into existing tables with ease. To learn more about importing data from cloud storages/drives, refer this documentation.
You can invoke the Import Wizard by clicking Import > Import into Existing Table option available at the top right corner of the table.
The following options are available:
How do you want to Import?: Choose how the data need to be added in the table using the drop-down list. The available options are:
Add records at the end: Use this option to append imported records to the end of the table.
Delete existing records and add: Use this option to delete entire records in Zoho Analytics table and add the new records into the table.
Add records and replace if already exists: Use this option to update the already existing records in the table with the new values and append the new records at the end of the table.
Add records, replace existing and delete missing record: Use this option to update the already existing records with the new values, append new records in the file to the end of the table and delete records that are not available in the file but present only in the table.
Note: When the Add records and replace if already exists or the Add records, replace existing and delete missing record option is selected, it is mandatory to specify matching columns. You can choose one or more columns as matching columns. Zoho Analytics will use the values in these columns as the key to match the existing records with the new records being imported. Hence the matching column(s) combination should uniquely identify each record in the table. Once a match is identified, then Zoho Analytics will update that existing record in the table with the new values present in the file being Imported. In case the specified matching column does not identify unique records, then all records will be appended at the end of the table.
File Type/Cloud Storage Type: Choose the type of file or cloud storage you wanted to import.
Data Location: Choose the data location. In case of choosing Web as data location, it will provide the following options. Choose the appropriate option and provide the full path to the URL in the field provided.
URL: Choose this to import data from a publicly accessible URL.
URL With Authentication: Choose this to import data from URL with basic authentication. On choosing this, you need to provide username and password to access data from the URL.
The remaining settings are similar to those present in importing data to create a new table. To learn more, refer this documentation.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.