Subset DataSheet

Data > Sheet > Subset

 

You can use Subset DataSheet to copy specified rows from the active datasheet to a new datasheet.

 

Dialog box items

DataSheets:
Choose the datasheet you want to subset.

Selected Rows:
Choose to copy selected rows to the new datasheet.

Subset Rows with:
Enter an expression that identifies the rows to use in the analysis. The expression must evaluate to a vector of logical values (TRUE values are used, FALSE values are dropped).

Save in:
Enter the name for the datasheet in which to save the results of the analysis. If a datasheet with this name already exists, this command returns all rows on a boolean column indicating subset membership.

Target Column:
Specify the name for the new column indicating subset membership. This is only relevant if the destination datasheet already exists.