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