topic Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)? in Discussions

How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

madhu — Thu, 14 Nov 2024 15:54:42 GMT

Is there any method in JMP Pro that can arrange the column names in alphabetical order (ascending and descending)?

I have named the variables by acronyms only (see examples below).

ACCMLAMEB	Is both the insured driver [you] and other driver jointly to blame for this incident? Yes/No 2
ACCMLAMEBR	If Yes/No, why? Give justification [in texts] between 50 and 100 words 3

DAMVICSIDE	Damage to vehicle/Point of impact [front/back/driver side/passenger side]
DASHCAMF	Did you have any dash cam fitted in your car during the accident? [Yes/No]
DASHCAMOP	Was the dashcam in full operation during the accident? [Yes/No]

LCLAIMY	What is the largest claim did you file in past with any insurer since you started driving? [in £ amount]
LICCAT	Category of driving license
LICYR	Number of years of driving license held
LINECHFRE	Frequency of Lane Changes per Trip
LOCINCC	Location of the incident [Country]
LOCINCD	Location of the incident [district name]
LOCINCS	Location of the incident [street name]

Currently, I can see the acronyms (abbreviations) of the variable definitions but not in order (see the attached screenshot). This takes me to time to locate the variable on the that I want to include in the model.

Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

hogi — Thu, 14 Nov 2024 18:18:02 GMT

you can reorder the columns "by name" via the Cols menu:

Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

txnelson — Thu, 14 Nov 2024 17:15:31 GMT

@hogi provides a way to interactively sort the columns into an ascending order. Here is a little script that will sort in either direction. It is currently set to sort them in a descending(reverse) order. Just remove the Reverse() function and the order will be ascending.

Names Default To Here( 1 );

dt = 
// Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

colNameList = dt << get column names( string );

colNameList = Reverse( Sort List( colNameList ) );

dt << move selected columns( colNameList );

It should also be noted that when using a selection box for any of the JMP Platforms, such as Distribution, Fit Y by X, etc. the column list in the dialog box allows for the ascending and descending ordering of the column names for selection

Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

madhu — Fri, 15 Nov 2024 01:35:53 GMT

Dear @hogi

This works. Thank you for your support.

Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

madhu — Fri, 15 Nov 2024 01:39:53 GMT

Dear @txnelson

Thank you for the solution. However, I am not familiar wit the script. How can I use the script you suggested?

Regards

Re: How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

txnelson — Fri, 15 Nov 2024 04:35:16 GMT

The example that I provided will open a sample data table called Semiconductor Capability, which happens to have something like 132 column. It will then reorder the columns in a descending alphabetical order. You will be able to observe the end result by clicking on the window for the data table.

To actually run the script, all you need to do, is to cut an paste the script from my response to a script window. And then run the script. To do this just

Go to

File=>New=>JSL Script

Right Click on the first line on the script and then select Paste

The script will be displayed in the script window.

Then to run the script, either click on the Icon with the green Run JSL triangle in the JSL tool bar at the top of the JMP window or Right Click anywhere on the script and select Run Script.

A very minor change to the script can set it up so that when ever it is run, it will do the reodering for whatever data table is the current active data table.

Names Default To Here( 1 );
dt = Current Data Table();
colNameList = dt << get column names( string );
colNameList = Reverse( Sort List( colNameList ) );
dt << move selected columns( colNameList );

If you want, this script can be added as a new tool on the tool bar that will set it up to run whenever the tool is clicked on. You can read up on how to do that under the JMP Help