User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
WebDesignesCrow
Super User WebDesignesCrow
Super User

How to rearrange column header using JSL script

Created: Aug 17, 2022 11:32 PM  |  Last Modified: Jun 9, 2023 10:07 AM (1709 views)

Hi,

I want to save my analysis table into Excel file (for others to see).

Because of new columns/ reference column added during my analysis using JMP, I couldn't delete the column before save in Excel.

How can I reorder the column so that those "less important column" for viewers move at the back.

 

Below is what I want:

Current Column Arrangement  
ABCDE
Wanted Column Arrangement  
ADEBC

 

It seems easy but I can't figure out how to do it.

Thanks !

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
David_Burnham
Super User (Alumni) David_Burnham
Super User (Alumni)
Solution

Re: How to rearrange column header using JSL script

Aug 18, 2022 02:20 AM (1698 views)  |  Posted in reply to message from WebDesignesCrow 08-17-2022

Here is a list of messages that you can use to reorder columns:

 

https://www.jmp.com/support/help/en/16.1/#page/jmp/rearrange-and-move-columns.shtml?os=win&source=ap...

 

Check out the scripting index for illustrative examples.

-Dave

View solution in original post

1 REPLY 1
David_Burnham
Super User (Alumni) David_Burnham
Super User (Alumni)
Solution

Re: How to rearrange column header using JSL script

Aug 18, 2022 02:20 AM (1699 views)  |  Posted in reply to message from WebDesignesCrow 08-17-2022

Here is a list of messages that you can use to reorder columns:

 

https://www.jmp.com/support/help/en/16.1/#page/jmp/rearrange-and-move-columns.shtml?os=win&source=ap...

 

Check out the scripting index for illustrative examples.

-Dave

Recommended Articles