Managing Attributes in the Data Manager

The attributes in the dataset are displayed in the Attribute List on the left-hand side of the Data Manager. These attributes can be selected, searched and ordered directly in this list (see possible operations below).

It is possible to modify the attributes by:

In the Attributes List, you can:

  • Add attributes to the current dataset;

  • Modify the existing attributes.

Prerequisites

  • You must have created a flow;

  • You must have linked the Data Manager task to the one containing the dataset you want to work on.

Procedure

  1. In the Attributes List, click on the three-dotted button next to the attribute you want to modify or right-click onto the attribute.
    In case you want to add a new attribute, click on the three-dotted button next to the dataset name.

  2. Select the required option among the ones listed below.

Available operations within the Attributes List

Name

Description

Check

To visualize the attribute on the dataset: the attribute is not deleted, it is only a visualization tool. You can choose among:

  • Check to display the attribute,

  • Uncheck to hide the attribute,

  • Invert to invert the selection

Delete

To remove the attribute from the dataset.

Edit

To change the attribute’s features, managing the missing values, and to set the normalization and distance parameters.

More information can be found in the Datasets and Attributes page.

Move

To change the position of the attribute in the table

Rename

To change the name the attribute. The attribute name must not contain the symbol $.

Ignored

To ignore the attribute in the analysis. The attribute won’t be deleted from the dataset.

Impute missing

To set the attribute’s missing value(s).

Set missing value

To fill empty cells with an average value suggested by Rulex. Alternatively you can enter a specific value manually. In both cases, you must click Impute Missing to apply the new values to empty cells.

Type

To change the attribute type from a list of possible values:

  • Binary

  • Continuous

  • Currency

  • Date

  • Datetime

  • Integer

  • Month

  • Nominal

  • Percentage

  • Quarter

  • Time

  • Week

Split

To split the attribute’s values into different columns. You can split the attribute by:

  • String: the attribute is split whenever the specific letters or characters are found.

  • Charlist: (characters' list) the attribute is split whenever the specific symbol is found. For example if you split 06/12/2021 by “/” you will have 3 columns.

  • Length: the attribute is split into chunks with the number of characters specified. If ABCDEF is split with a fixed length of 3 you will obtain two columns: “ABC” and “DEF”.

Search