Table of Contents

Add Table Column

Description

This functor creates a new column in the given table. The position where the new column is inserted determines whether the new column is a key or data column.

Inputs

Name Type Description
Table Table Type Table where the new column will be created.
Column Name Name Type The new column name.
Column Type Table Cell Type The new column cell type.

Optional Inputs

Name Type Description Default Value
Column Index Non Negative Integer Value Type Index representing the position where the column will be inserted. If the index is zero or greater than the last column index, the column is placed as the last table column. 0
Column Should Be Key Boolean Value Type This flag is meaningful only when the column is created after the last key column and before the first data column. If true, the new column represents a key column, otherwise, it represents a data one. True

Outputs

Name Type Description
Result Table Type The resulting table containing the new column.

Group

Table

Notes

This functor adds an empty column of the given type at the given position.

Example:

Given the table below

Key1* Key2* Value1 Value2
1 2 2.2 3.1
1 3 2.1 3.1
1 6 1.2 4.2
2 2 3.2 6.1

adding a column named “New_Column” of type “Real” at position 2 results in

Key1* New_Column* Key2* Value1 Value2
1 0.0 2 2.2 3.1
1 0.0 3 2.1 3.1
1 0.0 6 1.2 4.2
2 0.0 2 3.2 6.1

Internal Name

AddTableColumn