topic Easy way of reordering columns in Discussions

Easy way of reordering columns

Agustin — Fri, 09 Jun 2023 17:03:08 GMT

I have a script that reformats many files and performs some analysis producing a final summary table, however the order in which the calculations are done and new columns are added doesn't produce a very readable format.

I would like to pass the list of column names in the order I want them.

Is there a built - in way of doing this?

e.g. if I had a table with: Column 1, Column 2, Column 3, Column 4

I want to pass in the list {Column 2, Column 4, Column 1, Column 3} to the table and have the reorder the table columns to match.

Thanks!

Re: Easy way of reordering columns

txnelson — Fri, 01 Jul 2022 14:22:55 GMT

Here is the way I handle this. By working backwards through the list, and moving each to the first position, the columns end up as you want them.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
myList = {"age", "weight", "height"};
For( i = N Items( myList ), i >= 1, i--,
	Eval( Parse( "dt << Move Selected Columns(" || myList[i] || ", To first )" ) )
);

Re: Easy way of reordering columns

stan_koprowski — Fri, 01 Jul 2022 14:28:48 GMT

Nice, simple and clever solution @txnelson

Re: Easy way of reordering columns

Agustin — Fri, 01 Jul 2022 15:59:05 GMT

That's such an ingenious fix!