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 |
|
Options |
|
Outputs |
|
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.