Sort

The handler sorts the input data set records. The algorithm provides serial sorting by several fields.

The following parameters are taken into account while sorting:

• Order of sort fields: according to the item position in the Sort fields list, the field sorting order changes.
• Sort order: the sorting order ( Descending or Ascending) is set for each sorted field.
• Data case: case sensitivity of fields while sorting is specified for the fields with String or Variable data type.

The algorithm sorts the records by the first sort field according to the set order. If there are the same values, the strings that contain them are sorted by the second sort field, etc. according to the order of the sort fields.

Input

• Input data source: the port for connection of the input data set.

Output

• Output data set: the table with the data set sorted by the selected fields is output to the port.

Wizard

The fields by which it is possible to perform sorting are displayed in the left list. The list complies with the input port fields.

It is possible to filter the list of fields by specifying the field name or caption in the filter area.

To configure sorting, it is required to move the required fields to the Sort fields list using the following methods:

• drag-and-drop method;
• double click on the field;
• by pressing Add button.

Parameters of sorting configuration:

• Order: the field can take Ascending and Descending values;
• Case: to sort the string fields taking into account the case, it is required to select a checkbox in this field.

It is possible to change the fields sorting order:

• Move up enables to move the selected Sort field up the list.
• Move down enables to move the selected Sort field down the list.

To exclude sorting by the field, it is required to perform the following actions:

• move the record from the Sort field list to Available fields;
• double click on the field;
• Delete field.

To clear the whole list, it is required to press Delete all....

Note: Сharacters are compared and sorted according to the local settings of the user whose login is used to start Megaladata.