Importing Data into an Existing Table

• Importing Data
  • Importing Data from Files and Feeds
  • Importing Data from Cloud Storage
  • Import Settings

Virtutem Analytics allows you to import data from tabular format files like CSV, Excel (XLS and XLSX), JSON and HTML files stored in local drive and web feed or in different Cloud Storage/Drive such as Zoho Docs, Google Drive, Dropbox, Box and OneDrive into an existing tables. With this option, you can easily update (add/modify/delete) the records in your existing table. The data being imported can be in any file formats mentioned and can be available in your local machine or a URL or Web feed or even some application generated. You could also copy & paste the data into Virtutem Analytics and get it imported into the necessary table.

In this chapter, we will discuss about how to import data into an existing table in your database.

Importing data into an existing table is almost similar to   Importing data to create a new table   in Virtutem Analytics.

 Importing Data

 Importing from Files and Feeds

The following video illustrates importing into a table from files and feeds.

 Importing from Cloud Storage

The following video illustrates importing into a table from cloud storage.

 Importing option

You can invoke the Import Wizard by clicking   Import > Import into Existing Table   option available at the top right corner of the table. The Import wizard will show you the following options.

• How do you want to Import?   - Choose how the data need to be added in the table using th 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 Virtutem 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 Add records and replace if already exists   or   Add records, replace existing and delete missing record   is selected, it is mandatory to specify matching columns. You can choose one or more columns as matching columns. Virtutem 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 Virtutem 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 then 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.

Other Import settings are similar to how you   import data to create a new table . For details, refer to the Import data to create a new table section.