Sorting Data 

Use

With the  Sort Data transformation, you can sort data according to the selected fields. The node can be integrated into any point in an analysis process. Use the node if you would like to display the sorted data with the Display Data function.

The data structure does not change during sorting.

Functions

To sort the data, first all data in the data source is read, then it is buffered in the main storage or in the database and lastly it is made available in sorted form the transformations that follow.

Because almost all transformations perform sorts according to grouping fields, performing the sort beforehand with such transformations only leads to a decrease in performance because the data has been sorted once unnecessarily. The sorting transformation is particularly unsuitable for sorting data for the call of a routine transformation.

Activities

       1.      Select the fields according to which you want to sort.

       2.      Establish the sorting sequence. By default, the system sorts in ascending order, buy you can set the Descending indicator.

Example

Revenue is to be read from an InfoProvider in sorted form.  In addition to the InfoProvider data source, a node for sorting is to be added to the model. If you select the Revenue field as the sorting field and set the Descending indicator, when the analysis process is executed, the data at the exit of the node will be sorted by revenue in descending order.