Use the Group tab for group selection, which extracts a number of rows based on values in a particular column in the Start Table.
Name of the Start Table column used to select the data to extract. For example, you can extract a set of customer data based on values in the STATE column in the CUSTOMERS table. Click the arrow to select a column name.
As an example of group selection, you can extract a set of data based on values in the STATE column in the CUSTOMERS table:
Number of Unique Groups | Number of Rows per Group | |
To extract all rows of customer data from any 10 states. | 10 | blank |
To extract 50 rows of customer data from all states. | blank | 50 |
To extract 50 rows of customer data from any 10 states. | 10 | 50 |
You can combine selection criteria or an SQL WHERE clause with Group options. In this example, you can specify selection criteria to target up to 10 specific states.
For details on selection criteria, see Table Specifications.