A JSL script for moving columns to original order?

[#1]

Hello,

Is there a way to script this menu command: Columns/Reorder Columns/Original Order .

In the JSL manual, I found :

• dt<<Reorder By Name
• dt<<Reorder By Data Type
• dt<<Reorder By Modeling Type

In need to restore the column order to orignal order before Data Table update and reorder it by name after the update.

Thanks,

Claude B.

[#2]

It's unusual to have a menu command without a JSL equivalent. But if it's not there (I didn't check), you can make use of 'MainMenu()':

dt = Open("$SAMPLE_DATA/Big Class.jmp");

Wait(3);

dt << ReorderByName;

Wait(3);

dt = CurrentDataTable();

MainMenu("Cols:Reorder Columns:Original Order");

[#3 · Accepted solution]

It's simply

dt << Original Order;

[#4]

The best place to check out this kind of stuff is 'Help > Scripting Index', which usually has useful examples too, should you need them:

Clearly I need to use it more often myself . . .

[#5]

Thank you very much!

Both responses will be very useful in the future.

Claude