topic Re: Move Rows in Discussions

Move Rows

Dennisbur — Thu, 08 Jun 2023 16:32:13 GMT

Hello
I have calculated the table, but I want to move rows in this table.

For example, I want to move the GPIO row to the start of the table and the JTAG row after GPIO.

I tried to write this script, but something went wrong, can you assist me with this script?

dt << Move Rows ( {"GPIO"}, At Start );
dt << Move Rows ( {"JTAG"}, After( "GPIO" ) );

Re: Move Rows

txnelson — Thu, 02 Mar 2023 08:26:55 GMT

My suggestion is to open the Value Ordering column property, and change the order of the values in there, and then just sort the data table based upon the Parmeter column, and it will follow the Value Order you specified.

Re: Move Rows

Dennisbur — Thu, 02 Mar 2023 09:13:28 GMT

Is there a script command to move rows in a table?

Re: Move Rows

txnelson — Thu, 02 Mar 2023 11:14:14 GMT

Here is one way of moving a row:

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

rowToMove = dt[5, 0];
dt << delete row( 5 );
dt << add rows( 1, after( 12 ) );
dt[13, 0] = rowToMove;

Re: Move Rows

jthi — Thu, 02 Mar 2023 13:03:38 GMT

<< Move Rows seems to work with selected rows

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
r = dt << Select Rows([5, 7, 8, 10]);
Wait(2);
r << Move Rows(At Start);