Exclude selected rows

[#1]

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.

[#2 · Accepted solution]

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla

[#3]

That works fine, thanks.

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