topic Re: Exclude rows from linked Summary table in Discussions

Exclude rows from linked Summary table

RyMcQeN — Wed, 28 Feb 2018 18:42:03 GMT

Hello,

I have a linked summary table that I am trying to exclude rows based on some criteria of the cell contents for specific columns. The objective is for the rows in the linked table to also become excluded. I know it is possible to do this outside of JMP scripting but for some reason I get an error in JSL.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dtSummary = dt << Summary( Group(:age), Link to original data table(1));
r = dtSummary << Get Rows Where(:age == 14);
r << Exclude;

My actual code has more complicated row selection criteria but the above example has the same idea.

The error returned is:

ERROR: Send Expects Scriptable Object in access or evaluation of 'Send' , r << Exclude;

I appreciate any help in advance.

Thx,

Re: Exclude rows from linked Summary table

cwillden — Wed, 28 Feb 2018 18:40:36 GMT

Change "Get Rows Where" to "Select Where"

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dtSummary = dt << Summary( Group(:age), Link to original data table(1));
r = dtSummary << Select Where(:age == 14);
r << Exclude;

This worked on my end. Better yet, you can do it this way:

dtSummary << Select Where(:age == 14) << Exclude;

Get Rows Where() returns a list or the row numbers that meet the criteria. Sending an Exclude message to a list of numbers doesn't do anything, so that's why it wasn't working.

Re: Exclude rows from linked Summary table

RyMcQeN — Wed, 28 Feb 2018 20:33:53 GMT

Thank you for the quick response. I had tried Select Where earlier but had the wrong syntax. Appreciate the help!

-Ry