You can rearrange or sort data table columns by their name, data type, or modeling type, or reverse the current order. To reorder columns, select Cols > Reorder Columns and select from one of the following options:
Move Selected Columns
Moves the selected columns to a particular place in the data table. Specify where to place the selected columns in the Move Selected Columns window:
To first
Moves the selected columns so that they are in the left-most position in the data table.
To last
Moves the selected columns so that they are in the right-most position in the data table.
After
Moves the selected columns so that they are after a column that you identify.
Original Order
Returns the columns to the order they were in when data table was last saved.
Reorder by Name
Arranges the columns from left to right in alphabetical order by column name.
Reorder By Data Type
Arranges the columns from left to right in alphabetic order by data type (expression, row state, character, numeric).
Reorder By Modeling Type
Arranges the columns from left to right in alphabetic order by modeling type (none, continuous, ordinal, nominal, multiple response, unstructured text, vector). Row state columns have no modeling type, and are shown last.
Reverse Order
Reverses the order of the data table columns.