Skip to content

Creating datasets

Introduction

Datasets can be created in two ways: directly from the New Dataset window (New Dataset window) or from the list of datasets page (List of Datasets page). The particular features of the two methods are described below.

Create a dataset from the New Dataset window (Create new)

Application database > Analytical Workspaces tile > click the workspace tile > New dataset

Application database > Navbar > Analytic Information hub > click the workspace tile > New dataset

  1. In Dataset creation mode, select Create new.
  2. Set the characteristics of the new dataset, then click OK: the dataset will be created offline.

Create a dataset from the New Dataset window (Load file)

Application database > Analytical Workspaces tile > click the workspace tile > New dataset

Application database > Navbar > Analytic Information hub > click the workspace tile > New dataset

This follows a guided procedure. Only non-partitioned datasets can be created from file. It is also necessary to have one file to be loaded which contains the settings of the dataset to be created in .csv format according to Standard RFC-4180.

  1. In Dataset creation mode, select Load file: all settings will be disabled.
  2. Click Next, then Upload and select the file to load.
  3. If the predefined setting UTF8 is selected in Charset, click Next: the file will be imported.
  4. If a setting other than UTF8 is selected in Charset, click Next. The following outcome will be obtained:
If... Then...
the file is correct the file is imported and all columns of the file are recognised as being Text type.
the file is not correct an error is returned because the file is considered non-interpretable.
5. Click Next: the Customise dataset window will open, showing the Preview with the first 10 rows of data from the file and the column headers, and the data type is indicated for each column.
6. To create a Form that is also linked to the dataset, select Create Data Entry Form and select a process from the list

Note: only active processes are shown in the page.

  1. If necessary, in Dataset Fields, exclude one or more columns using the dedicated button. These are also automatically removed from the Preview.

Note: at least 1 column must be included, otherwise an error message will be shown. 2. If necessary, in Dataset Fields, change the data type, choosing between Text, Number and Date.

Note: when one or more rows in the loaded file contains fields with values that do not mirror the type recognised or chosen in the Preview window, on running the data processing, these rows will not be imported into the created partition and/or forms.

Data type: Date

The following formats are recognised as Date type and when the data processing is run, datasets, partitions and forms are created successfully. Data containing these formats are correctly imported.

  • "yyyy-MM-dd"
  • "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"

The following formats are recognised as Text type and, by changing the type to Date, when the dataset is run, datasets, partitions and forms are created successfully and data containing these formats are correctly imported.

  • "yyyy-MM-dd'T'HH:mm:ss.SSS"
  • "yyyy-MM-dd HH:mm:ss.SSS"
  • "yyyy-MM-dd HH:mm:ss"
  • "yyyy-MM-dd HH:mm"

Create a dataset from the list of datasets

Application database > Analytical Workspaces tile > workspace tile > List of Datasets

Application database > Navbar > Analytic Information hub > workspace tile > List of Datasets

It is not possible to create several Datasets simultaneously using this procedure.

  1. Click to add a new dataset to the list.
  2. Define its attributes, then click Save: the dataset is created offline.
  3. If there are users with restrictions on the Workspace datasets, deploy the user rights on the Analytical Workspace datasets as follows:
If... Then...
the user restrictions are defined at the workspace level and not directly on individual datasets run deploy: the data of the new dataset become available for users with restrictions.
the restrictions were defined on individual datasets include a new item in the definition of the user rights over the datasets and then run deploy again: the data of the new dataset become available for specific users.