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

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