Reorder Table Column

Description

Move a column to a new position.

It is possible to move key or data columns. However, data columns can not be moved to a position occupied by a key column or vice-versa.

Inputs

Name	Type	Description
Table	Table Type	The input table.
Column Index Or Name	Index Or Name Type	Index or name of the column to be moved.
New Column Index	Non Negative Integer Value Type	Column index where the specified column will be re-inserted. The column currently located at this position (and all following columns) is shifted to the next position. The use of 0 forces the column to become either the last table column or the last key column.

Outputs

Name	Type	Description
Result	Table Type	The resulting table.

Group

Table

Notes

Key and data columns can not be mixed. Thus, it is not possible to move a data column to a position occupied by a key column and vice-versa.

If a key column is being moved to a position occupied by a data column or if a data column is being moved to a position occupied by a key column, the column is moved to the position immediately after the last key column.

The position 0 means the last key column or the last data column, depending on the column being moved.

Internal Name

ReorderTableColumn