User guide

Data Integration with Sybase Avaki Studio 109
Aggregate
Aggregate properties
Double-click an Aggregate operator to display the Aggregate Properties dialog. You
can edit the name and description as described in “Properties dialogs” on page 58.
Defining aggregate columns
Do the following to edit the column definitions of your aggregation.
• 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.)
• You can edit the properties of each column. (See “Working with schemas” on page 60
for information about the setting the name, type, precision, and scale of columns.)
 Name: Click in a column’s Name field to rename it.
 Expression: Click in the column’s Expression field to edit it. This may be any
JavaScript expression that you want to pass to the aggregate function, including
simple column names from the incoming result set. Click the “…” button to
open the Edit Expression dialog if you need more room than the table cell pro-
vides. You can also right click (either in the table cell directly, or in the Edit
Expression dialog) to show a context-sensitive menu of column names, vari-
ables, and functions that you can paste into the Expression field. For details on
using JavaScript expressions, see “Using expressions within Avaki Studio” on
page 66. For details on the context menu, see “The expressions menu” on
page 71.