Add Table Column

Description

This functor creates a new column in 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	Table where the new column will be created.
Column Name	Name	The new column name.
Column Type	Table Cell	The new column cell type.

Optional Inputs

Name	Type	Description	Default Value
Column Index	Non Negative Int 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	Bool	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	The resulting table containing the new column.

Group

Table

Notes

This functor adds an empty column of the given type at the given position. For 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 yields

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