How to rearrange column header using JSL script

[#1]

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
A	B	C	D	E
Wanted Column Arrangement
A	D	E	B	C

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

Thanks !

[#2 · Accepted solution]

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.