topic Re: How to use JSL to select many consecutive rows in a table? in Discussions

How to use JSL to select many consecutive rows in a table?

lwx228 — Fri, 29 Mar 2019 08:27:05 GMT

How to use JSL to select many consecutive rows in a table?
The table is already in the second column of the selection, how to use JSL to cancel all the selection, and then select the number of rows specified by the number of consecutive rows, select all the columns.
Take dt = Open( "$SAMPLE_DATA/Big Class.jmp" ) for example.
The expression for a row of consecutive choices was not found in the help.

Thanks!

Re: How to use JSL to select many consecutive rows in a table?

lwx228 — Fri, 29 Mar 2019 08:31:10 GMT

dt = Current Data Table();
dt << Go To( Column( 2 ) );
dt << Clear Column Selection();
Wait( 0 );
dt << Set Selected Rows( dt[6 :: 13] );
Wait( 0 );

This JSL cannot be implemented

Re: How to use JSL to select many consecutive rows in a table?

ian_jmp — Fri, 29 Mar 2019 10:12:29 GMT

Try:

dt << select Rows(6::13);

'Help > Books > Scripting Guide' coupled with 'Help > Scripting Index' are good resources.

Re: How to use JSL to select many consecutive rows in a table?

lwx228 — Fri, 29 Mar 2019 10:53:54 GMT

thank ian_jmp!

After selecting rows, how does JSL implement deselect all selections?Make table without any cell selection, thank!

Re: How to use JSL to select many consecutive rows in a table?

lwx228 — Fri, 29 Mar 2019 11:11:36 GMT

"dt << Clear Select()" Sometimes it doesn't work.

Re: How to use JSL to select many consecutive rows in a table?

uday_guntupalli — Fri, 29 Mar 2019 14:45:33 GMT

@lwx228 ,

Try this ?

dt = Open("$SAMPLE_DATA/Big Class.jmp");

// Clear Row Selection 
dt << Select Randomly(0.1); 

dt << Clear Select(); 

// Clear Column Selection 

dt << Select columns({:age,:sex}); 

dt << Clear Column Selection();