To configure a Group By operator you specify groups, specify aggregate columns, and (optionally) edit general properties.
-
Double-click a Group By operator.
The
Group By Properties dialog appears, with tabs for group-by columns and aggregate columns.
-
(Optional) Edit the name and description of the operator.
-
On the Group By Columns tab of the properties
dialog, list the columns from the input that this Group By operator will use to group
the incoming rows.
-
(Optional) Edit the column definitions.
| Action |
Instructions |
|---|
| Add column |
Click Add. |
| Delete column |
Select one or more columns (which are represented by rows in the properties dialog), then click Delete. |
| Reorder columns |
Select one or more columns, then click Move Up or Move Down. (To move multiple columns, the selection must be contiguous.) |
-
On the Aggregate
Columns tab,
specify aggregate columns.
-
Click OK to save the information and close the dialog.