Skip to main content

Following steps to create dataset using Flatfiles

  • From this document, you will learn to create a dataset in AIV, Also you will learn to make a dataset using Flatfiles. F

What is Flat-File?

  • A flat file database is a collection of records in which the data follows a uniform format and follows rules on value types where applicable. The database is flat because every line only holds one data input, depending on the categorization of the columns.
info
  • Click here to know more about Flat-File in detail.

Objectives

  • Create dataset using flat-files

Prerequisites

  • For this example we are using worldcities.xlsx.

Download excel.zip file from link given excel.zip & use data from the file named worldcities.xlsx from it.

  1. Go to Hamburger Icon > Master Data > Dataset.

    Docusaurus Slash Introduction

  2. Click on Create Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  3. Enter following details in Create Dataset.

  • Name: World Cities
  • Datasource: Flat Files
  • Copy Excel file data and Paste in Source window.
  1. Use worldcities.xlxs from the zip file you have downloaded at the start of this document to copy the required data.

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

    Docusaurus Slash Introduction

  3. Click on output Column Tab.

  4. Click on Preview and Submit button.

  5. You will see the World City Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  6. Click on Hamburger menu > Dashboard section & create dashboard.

    Docusaurus Slash Introduction

info
  1. From Right Vertical Menu Select the Table Widget icon.

    Docusaurus Slash Introduction

info
  • CLick here to know more about different dashboard widgets.
  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: World Cities
  • In Dataset Column Select all the field.

Docusaurus Slash Introduction

  1. Click on Preview and Save and Exit button.

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

    Docusaurus Slash Introduction

  • In this manner, you can create a new dataset for your Dashboard.

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

Dataset using CSV

Dataset using JSON

Dataset using External sources

Dataset using Excel

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