How to: Reference: |
You can specify a sort to determine the order in which new columns appear in the results. A sort orders your results according to the results of a column you choose. When sorting by multiple columns, the first sort field sets the major sort break, the second sets the second sort break, and so on.
A sort is useful only in some cases. Use the following guidelines to consider whether or not to include a sort in your data flow.
The Sort Columns dialog box opens.
or
Select the column you want to sort on and click the right arrow.
The column is added to the Sort Columns box.
Note: Clicking a column heading will sort the column grid on that heading.
To access the Sort Columns window from the data flow workspace, right-click the SQL object and select Sort.
The Sort Columns window contains the following fields and options:
Is a list of columns available in the data source.
Is the name of the column.
Is the format of the column.
Is a description of the column.
Note: Clicking a column heading will sort the column grid on that heading.
Indicates if the column can contain NULL values.
Is a list of sort columns.
Is the column(s) that sorts the results.
Specifies whether results are sorted in ascending or descending order.
Is the column aggregation, if one has been applied.
Add or remove sort columns.
Allows you to search for a column.
Tests the SQL statement and displays the result.
Note: The test button will be grayed out if you have not selected any columns.
Move the selected sort column to change the order of the sort breaks.
iWay Software |