Specify how to group the result rows by one of the following methods:
- Specific number of rows.
- Specific field.
- Specified duration of time.
You can use the result rows in a transformation or job entry, or you can get the records themselves by using the Get rows from result step in a transformation.
To access the Field to group rows on or Duration time when collecting rows options, delete the default value in the Number of rows to send to transformation option.
| Option | Description |
|---|---|
| Number of rows to send to transformation | Specify a number. After every n number of rows, the job will be executed and these n rows will be passed to the transformation. |
| Field to group rows on | Specify a field for grouping rows. Rows will be collected in a group as long as the field value stays the same. If the value changes, the job will be executed and the accumulated rows will be passed to the transformation. |
| Duration time when collecting rows | Specify a time in milliseconds. This value is the amount of time the step will spend collecting rows prior to the execution of the job. |