What is the ‘Select’ task?
The ‘Select’ task can be used to select a precisely defined region or segment of a data table. The selection can be of precisely defined contiguous or non-contiguous regions, or even a random selection.
How to use the ‘Select’ task?
The important fields in the ‘Select’ task are
- Select Table
Use this dropdown menu to select the table from which you would to select data entries.
- Select Type
Use this dropdown menu to define the type of selection. There is a wide range of selection types, including ‘First N’, ‘Last N’, ‘First N%’, ‘Last N%’, ‘Random N’, and ‘Every Nth Record’.
- Input N
Use this field to type in the value of N.
For example, if you input 5 in this field, and select ‘First N’ in the ‘Select Type’ field, the output table will have the first 5 entries from the input data table.
- Select Group Columns
Use this dropdown menu to select the column in which N should be applied.
How to use the ‘Define Output Tables’ and the ‘Output Options’ sections in the ‘Select’ task?
The ‘Output Options’ section in the ‘Select’ task can be used to modify features of the output table. The fields related to this section become visible on selecting the ‘Output Options’ checkbox.
More information about this section is available here.