Order Selected Columns
Created:
| Last Modified:
Most of the column ordering options found from JMP's Cols/Reorder Columns -menu do not offer possibility to order only selected columns. This add-in provides that option to JMP users. Idea for addin came from JMP Community Wish List - Column reorder Sort by Name / Data Type / Role SELECTED COLUMNS ONLY.
Currently the sorting options provided are:
- Order Selected Columns by Name
- Order Selected Columns by Data Type
- Order Selected Columns by Modeling Type
- Reverse Selected Columns
After the add-in has been installed, new sub-menu will be added to Cols menu called Reorder Selected Columns (Add-In):
The add-in does provide couple of options user can change through Change Settings. In the current version, these settings will be overwritten if the add-in is reinstalled.
Ordering behaviour:
With this option user can select if the columns should be only sorted within the column selection, or if the columns be sorted and then moved next to first selected column (default behaviour).
Behaviour when no columns selected:
With this option user can decide if the addin should uses JMP's default sorting options if no columns are seleced (default behaviour) or throw an error when no colums are selected:
Save table script:
With this option enabled table script will be saved to datatable which can then return the order of columns before the sorting was ran (defaults to on).
Table scripts are named based on the sorting user did: Return Column order before sorting by Name for example and after running the table script following is printed to log (timestamp is in JMP's datetime format):
"Returned column order saved at " || "3725088824" = "Returned column order saved at 3725088824";
Add-in and code can also be found from GitHub - Order Selected Columns (not updated)
Change Log:
- 2023 - 01 - 28
- Fixed issue with modelling type and name ordering
- Prevented add-in usage with JMP17
