BookmarkSubscribeRSS Feed
matthewh

Community Trekker

Joined:

Jun 23, 2011

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
Solution

Re: Exclude selected rows

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla
2 REPLIES
Solution

Re: Exclude selected rows

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla
matthewh

Community Trekker

Joined:

Jun 23, 2011

Re: Exclude selected rows

That works fine, thanks.

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