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.
See ReorderTableColumn in Manipulating Tables and Lookup Tables for how this functor is used together with other table functors.
Internal Name
ReorderTableColumn