Adding a column to an existing Dataset

<< Click to Display Table of Contents >>

Navigation:  Business Insights - Datasets for reporting and process mining > Using Business Insights service > Creating a Dataset >

Adding a column to an existing Dataset

Overview

After you create a dataset, you may need to update its structure definition by adding an extra column. This section describes how to add a new column to an existing Dataset in any environment.

 

Procedure

To create a new column in a dataset, click the Add column option in the three dots menu for the Dataset.

 

Cloud_Datasets_AddCol01

 

The New Column window appears. Provide the Name and select the Data type for the new column.

You can choose String, Numeric, Boolean or Datetime as the Data type.

 

Cloud_Datasets_AddCol02

 

Select a default value for the new column; this value will be set for every existing record in the dataset. You can choose null to set an empty value or custom to set a predefined value according to the Data Type selected.

When you are done, click Create column.

 

note_pin

It is not possible to add new columns of collection data type. Likewise, new columns can not be business keys.

 

When you add a new column to a dataset, you have to download the dataset connector again and overwrite it in Bizagi so the new column appears in the mapping window.