HMSyncTOC("index.html", "cloud_dataset_addcolumn.htm");

Adding a column to an existing Dataset

<< Click to Display Table of Contents >>

Adding a column to an existing Dataset

 

Adding a column to an existing Dataset

  •     Overview
  •     Procedure
  • 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.

     

    In this article