The Set Selection output settings enable you to customize the values that the utility uses to output records. The following table describes the settings that are specific to the Set Selection utility.
| Setting | Description |
|---|---|
|
Min no of rows per set, for set to be processed |
Numeric value that specifies that each selected set must contain at least this many rows. For example, if it is set to 2, then every set will contain 2 or more rows. |
| Max no of rows per set, for set to be processed | Numeric value that specifies that none of the selected sets will contain more than this many rows. For example, if it is set to 10 then sets with 11 or more rows will be excluded. |
| Max no of sets to be processed | Numeric value that limits the total number of key sets to process. |
| Max no of rows to process per set | Specifies the maximum number of total rows to process. |
| Attribute to use for group sequence numbering |
Attribute that will be populated with the sequence number within the current set. |
| Row filter |
An expression that defines conditions for filtering output rows. For more information, see Filtering Rows with Expression Builder . Note: The aggregate Set Selection functions cannot be used for output row
filters, only for input conditionals and Attribute Transformation.
|
| Debug option | When on, debug information is written to a log file. The default is off. For more information, see Debug Settings. |
| Sample Count | This controls the reporting increment of the number of rows processed count. These counts are written to the process log starting at the specified value. This output allows you to track progress and helps troubleshoot any problems. By default, this field is blank. If no value is entered, no rows are written to the log file. |