cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
matthewh
Level I

Exclude selected rows

OK, I know this is simple, but I can't work out how to do it.

What is the JSL script for excluding rows that are selected?

Currently, I am excluding rows by creating an additional column called IgnoreRow, with a value of 1 for rows to be excluded and 0 for all other rows (this calculation is based on the contents of other columns). I then use:

For Each Row( Excluded( Row State() ) = :IgnoreRow );

which is fine for small tables, but takes forever with large tables. What I'd like to do is to select the rows to be excluded and exclude them all at once, much like I would interactively (which is quicker). I tried this but it didn't work:



There may be a much simpler way, but I'm no clearer from reading the JSL guide. Can anyone help?

Thanks,
Matthew.
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Exclude selected rows

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla

View solution in original post

2 REPLIES 2

Re: Exclude selected rows

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla
matthewh
Level I

Re: Exclude selected rows

That works fine, thanks.

Back to school for me, it seems... :-(