Defining data to be sorted

Before you can restructure the data, you must sort the data.

These are the input parameter properties for sorting:

Sorting Sequence

By default, this property is set to 0, which means no sorting. When Sorting Sequence is set to a positive integer value, the data is sorted on that element. You can set Sorting Sequence for several input parameters for a Restructure function.

Follow these example sorting sequence:

  • Sort on supplier name (Sorting Sequence = 1)

  • Sort on IBANID ()

Note: A Sorting Sequence value that is Sorting Sequence = >0 must be unique within a Restructure function.

Sort Order

If Sorting Sequence is >0, you can set the property Sort Order to Ascending or Descending sort order.

Note: All data are handled as strings and sorted lexicographically according to the Unicode Collation Algorithm (UCA). For more information on UCA, see http://unicode.org/reports/tr10/.

For example, 11 is less than 2 due to the different lengths for ascending sort order.

The null value for a non-existing input element is less than the lowest value for an existing input element. This means, null is less than an empty value and any other value for ascending sort order.

These input parameter properties decide the sorting for the data at the current loop level. The total sorting is constructed from the sorting properties for Restructure functions for all nested restructure loops. See this example:

If data for the outmost restructure loop is sorted on:

  • 1 supplier name

  • 2 IBAN ID

And, if data for the inner restructure loop is sorted on:

  • date

This becomes the total sorting:

1 supplier name,

2 IBAN ID, and

3 date