Reorder Table Column
Description
Moves a specified column of a table to a new position.
Inputs
| Name | Type | Description |
|---|---|---|
| Table | Table Type | Table whose column will be reordered. |
| Column Index Or Name | Index Or Name Type | Index or name of the column to be moved. The first, i.e. the leftmost, column has index 1. |
| New Column Index | Non Negative Integer Value Type | Index of the column at which the moved column will be re-inserted. The column currently at this position, and all columns after it, are shifted one position to make room. |
Optional Inputs
None.
Outputs
| Name | Type | Description |
|---|---|---|
| Result | Table Type | The resulting table with the column moved to its new position. |
Group
Notes
Key columns and data columns cannot be mixed: a data column cannot be moved to a position occupied by a key column, and vice versa.
If a key column is moved to a position occupied by a data column, or a data column is moved to a position occupied by a key column, the column is instead moved to the position immediately after the last key column (equivalently, immediately before the first data column).
A New Column Index of 0 moves the column to the last position among key columns or data columns, depending on which kind of column is being moved.
Internal Name
ReorderTableColumn