User guide

Data Integration with Sybase Avaki Studio 123
Group By
• You can edit the properties of each column:
 Name: Click in the Name field and choose a column name from the pull down
list to change it. (When you add a new column, Studio chooses the next avail-
able column from the input, which may not necessarily be the column you want
to group by).
 Keep in Schema: This determines whether the column in question will appear in
the output schema of the Group By operator. To change its value, click in the
field and choose either “Yes” or “No” from the pull down.
Specifying aggregate columns
Specify aggregate columns to calculate using the Aggregate Columns tab in the Group
By Properties dialog. This tab functions exactly the same as the column definition sec-
tion in the Aggregate Properties dialog (see “Aggregate” on page 108 for details).
To edit the column definitions of your aggregation, do the following:
• Click the Add button to add a column definition to your aggregation.
• To delete one or more columns, select them and click Delete.
• To reorder the columns, select one or more of them and click the Move Up or
Move Down buttons. (If you want to move multiple columns, the selection must be
contiguous.)