15763_en-US

liliconcom

A JSL script for moving columns to original order?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hello,

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

In the JSL manual, I found :

• dt<
• dt<
• dt<

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.

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

Thank you very much!

Both responses will be very useful in the future.

Claude

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

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

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

It's simply

dt << Original Order;

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

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