1.3.11.57 Sort Array

The Sort Array processor sorts the element values in an array in either ascending or descending order according to the data type of the array. All number array attributes are sorted by numeric value while string array attributes are sorted by characters.

The following table describes the configuration options:

Configuration Description

Inputs

  • Selected Attributes: One or more arrays to be sorted. Supports Date Array, Number Array, and String Array types. Each array can be of different type.

Options

  • Ascending Order: Whether to sort in ascending or descending order. Default value is Ascending.

  • Locale: Determines which locale to use while sorting the arrays. The default selection is EDQ Locale, however, it can be changed to any other desired locale such as English (United Kingdom), English (United States), French, German, Italian, and other languages.

Outputs

  • SortedArray: Resulting array after sorting.

Output Filters

None

Example

Input Values Sort Order Outputs

(A)(D)(C)(B)

Ascending

(A)(B)(C)(D)

(2) (5) (7) (3) (4) (6) (12)

Ascending

(2) (3) (4) (5) (6) (7) (12)

(2) (5) (7) (3) (4) (6) (12)

Descending

(12) (7) (6) (5) (4) (3) (2)

(18-Feb-2015 12:00:00)

(2-Mar-2015 12:00:00)

(20-Jan-2015 12:00:00)

(1-Dec-2014 12:00:00)

Ascending

(01-Dec-2014 12:00:00)

(20-Jan-2015 12:00:00)

(18-Feb-2015 12:00:00)

(02-Mar-2015 12:00:00)

(A) (D) (C) (<Blank>) (<Null>) (B)

Ascending

(<Null>) (<Blank>) (A) (B) (C) (D)

Note:

All the null entries in an array are sorted “above" all other values.