M2M AD301 Podręcznik Użytkownika Pobierz pdf (Strona 135)

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.)

1 2 ... 130 131 132 133 134 135 136 137 138 139 140 ... 229 230

Brak uwag

M2M AD301 Podręcznik Użytkownika Strona 135