Importing Data into an Existing Table
We will discuss the following sections in this documentation:
Importing data
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.
Import data from files and feeds
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.
Import data from cloud storage
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.
Import settings
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.
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:
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Importing data from MariaDB
If you have your data stored in MariaDB local database, you can easily import the data into Zoho Analytics or connect live with the MariaDB for advanced reporting and analysis. Data Import: Data from your database will be imported and stored in Zoho ...Creating a New Table
Zoho Analytics provides different options to create a table to store your tabular data. As already discussed, once you create a workspace you can create any number of tables within it. Please note that only Server Administrators and Managers can ...Import data from files
If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...Import data from Feeds
If you have data stored in web URLs in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...Import data from PostgreSQL
If you have your data stored in PostgreSQL local database, then you can easily import your data into Zoho Analytics for reporting & analysis. Data Import 1. How do I import data from the PostgreSQL local database? 2. How can I edit the setup? You ...