topic Re: A JSL script for moving columns to original order? in Discussions

A JSL script for moving columns to original order?

claude_bellavan — Sun, 06 Dec 2015 23:48:16 GMT

Hello,

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

In the JSL manual, I found :

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.

ian_jmp — Mon, 07 Dec 2015 08:20:08 GMT

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");

ms — Mon, 07 Dec 2015 08:28:34 GMT

It's simply

dt << Original Order;

ian_jmp — Wed, 19 Oct 2016 01:20:24 GMT

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 . . .

claude_bellavan — Mon, 07 Dec 2015 16:00:27 GMT

Thank you very much!

Both responses will be very useful in the future.

Claude