Exclude selected rows

matthewh — Tue, 06 Oct 2009 13:56:21 GMT

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.

Re: Exclude selected rows

Tue, 06 Oct 2009 14:16:38 GMT

You can exclude selected rows with the statement:

dt0 << exclude;

Is this already what your looking for?

Dahla

Re: Exclude selected rows

matthewh — Tue, 06 Oct 2009 14:25:56 GMT

That works fine, thanks.

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

topic Re: Exclude selected rows in Discussions

Exclude selected rows

Re: Exclude selected rows

Re: Exclude selected rows