topic Reorder source table columns - from Data Table Columns Viewer in Discussions

Reorder source table columns - from Data Table Columns Viewer

Heinrich — Thu, 08 Jun 2023 16:27:08 GMT

Dear all,

In the Data Table Colums Viewer there is the table Summary Statistics and in the red triangle menu i can select the command Reorder source table columns. My question is how can I run this command in a script?

Thanks for any ideas..

Re: Reorder source table columns - from Data Table Columns Viewer

txnelson — Mon, 20 Mar 2023 15:58:02 GMT

The Column Viewer option "Sort By Name" only sorts an internal list of the column names. It does not change the order of the columns in the data table. It does change the order of the statistical output, for any Show Summary requests that are made after a "Sort By Name" has been selected.

To do a similar item in JSL, the below example would be one way to accomplish it.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

myColList = dt << get column names();

myColList = sortlist(myColList);

dt << summary( n(eval(myColList)));

Re: Reorder source table columns - from Data Table Columns Viewer

Heinrich — Mon, 20 Mar 2023 16:11:22 GMT

Thanks for the answer.

However i would like to sort the columns in the source table according to the amount N in Summary Statistics.

Here is my script so far.

Names Default To Here( 1 );
dt = Current Data Table();

Main Menu( "columns viewer" );

w = Window("Data Table Columns Viewer");
w[ButtonBox(1)] << Click;
w[ButtonBox(3)] << Click;
w[Table Box (1)] << Sort By Column ("N");

And then I would like to send this reorder command.