Skip to content
AIV

Dataset Using CSV

  • From this document, you will learn to create a dataset in AIV, Moreover, you will learn to make a dataset using CSV(Comma-separated values).

What is CSV?

  • A comma-separated values file is a delimited text file that uses a comma to separate values & that file is a plain text file that contains a list of data. These files are often used for exchanging data between different application. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

  • Click here to know more about CSV files.

Objectives

  • Create dataset using CSV File

Prerequisites

  • For this example we are using employees.csv

Download csv.zip file from link given csv.zip

  • After downloading the zip file, add it into the AIV. To add it into AIV follow this Link.

Dataset using CSV: This video contains how to create Dataset using CSV in AIV.

Steps to create dataset using CSV

  1. Click on Hamburger Icon & go to Documents Tab.

    Image

  2. In Documents tab Click on Shared Resource.

  3. In Shared Resource Click on upload, As shown in figure below:

    Image

  4. When you click on Upload it will display a screen.

  5. In Upload Files upload a csv file, As shown in figure below:

    Image

  6. Click on Upload button.

  7. You will get a message, As shown in figure below:

    Image

  8. In Master Data Tab click on Dataset.

  9. Click on create dataset, As shown in figure below:

    Image

  10. Enter following details in Create Dataset.

  • Name: Card_details_dst
  • Datasource: Existing Files
  • Select Card_details.csv file in Available to selected.

  1. Fill above details, As shown in figure below:

    Image

  2. Click on the Select from the center of the screen & then click on Preview and Submit button.

  3. You will see the Card_details Dataset, As shown in figure below:

    Image

  4. Click on Hamburger menu > Dashboard section & open your dashboard.

    Image

  1. From left Vertical Menu Select the Table Widget icon for this example.

    Image

  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: Card_details_dst.ds
  • Select all the Field in Dataset Column.

  1. Fill above details, As shown in figure below:

    Image

  2. Click on Publish and Save button.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Image

✒️To know more about how to create dataset using different sources follow below Links:-

Dataset using Excel
Dataset using Excel
Dataset using JSON
Dataset using Flatfiles
Dataset using External sources
Dataset using Google BigQuery
Dataset using noSQL

Dataset using Join
Dataset using Union
Dataset using Server Script
Dataset using Client Script
Dataset using Stored Procedure
Dataset using View
Dataset using Simple Query
Dataset using Drag & Drop