User guide

Operator reference
122 Data Integration with Sybase Avaki Studio
Performance notes
Because Studio needs to sort the result set in order to perform a grouping, the same
performance issues described for the Order By operator apply to the Group By oper-
ator. See “Performance notes” on page 159 for details.
Group By properties
Double-click a Group By operator to display the Group By Properties dialog. You can
edit the name and description as described in “Properties dialogs” on page 58.
Specifying groups
On the Group By Columns tab of the properties dialog, you list the columns from the
input that the operator will use to group the incoming rows. You may note the similar-
ity to the way the Order By operator specifies the columns used for sorting (see
“Order By” on page 159 for more information).
• Click the Add button to add a column criterion to your groupings.
• To delete one or more columns, select them and click Delete.
• To rearrange the columns, select one or more of them and click the Move Up or
Move Down buttons. (Note that if you want to move multiple columns, the selec-
tion must be contiguous.)