topic Re: Number of selected rows in Discussions

Number of selected rows

ms — Wed, 06 Apr 2011 21:36:06 GMT

In the lower left pane of a JMP data table there is a list with row information, including the number of currently selected cells.

Is there a JSL command that can retrieve that information directly? I can of course loop through all rows and count all selected cells. However, it may be more efficient to grab a number that JMP already seem to have calculated automatically.

I am asking because I am running a script that conditionally selects different sets of rows in a huge table and want a fast way to neglect sets with too few rows.

Re: Number of selected rows

pmroz — Fri, 22 Jun 2018 16:16:46 GMT

num_selected = nrows(dt << get selected rows);

Re: Number of selected rows

ms — Thu, 07 Apr 2011 12:57:56 GMT

Thanks! Just what I was looking for. Simple and elegant.

Re: Number of selected rows

robust1972 — Wed, 19 Oct 2016 02:26:31 GMT

hi, PMroz

I am trying to select certain rows in a table with a criteria and then delete them if the number of selected rows is greater than 0 as below but got the error as inserted pic.

if( (nrows(dtlist8<< get selected rows()))>0,

dtlist8 <<delete rows,

);

Re: Number of selected rows

pmroz — Fri, 22 Jun 2018 16:17:12 GMT

What is dtlist8 pointing to? It seems like it isn't pointing to a table. The following code works:

dtlist8 = open("$sample_data\Big Class.jmp");
if( nrows(dtlist8 << get selected rows()) > 0,
      dtlist8 << delete rows,
);