A data sort sorts incoming rows by one or more data structure columns.
- Select the Data Sort tool in the Toolbox, and create the action in the diagram.
- Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data sort to initialize it with the incoming data structure columns.
- Double-click the data sort symbol to open its property sheet, click the Sort Columns tab and click the Select Sort Columns tool to open a selection dialog box, which allows you to select one or more columns to sort by. Make your selection, click OK to add the columns and return to the tab.
- For each of the sort column, click in the Order column, and specify whether it should be sorted in ascending (default) or descending order.
- Click OK to save your changes and return to the diagram.
Note:
You can right-click a data sort symbol, and select Sorted Columns to access the Sort Columns tab directly.
