Sorter

This node sorts the rows according to user-defined criteria. In the dialog, select the columns according to which the data should be sorted. Also select whether it should be sorted in ascending or descending order. Additionally, provides the option to compare string-compatible columns in alphanumeric instead of lexicographic order, for example "Row2" before "Row10" instead of "Row10" before "Row2".

Options

Sorting
A list of sorting critera.
  • Column: Sort rows by the values in this column. If you set multiple sorting criteria, the table is sorted by the first criterion. The following criteria are only considered, if the comparison by all previous criteria results in a tie.
  • Order: Specifies the sorting order:
    • Ascending: The smallest or earliest in the order will appear at the top of the list. E.g., for numbers the sort is smallest to largest, for dates the sort will be oldest dates to most recent.
    • Descending: The largest or latest in the order will appear at the top of the list. E.g., for numbers the sort is largest to smallest, for dates the sort will be most recent dates to oldest.
  • String comparison: Specifies which type of sorting to apply to the strings:
    • Natural: Sorts strings by treating the numeric parts of a string as one character. For example, results in sort order “'Row1', 'Row2', 'Row10'”.
    • Lexicographic: Sorts strings so that each digit is treated as a separated character. For example, results in sort order “'Row1', 'Row10', 'Row2'”.
Sort missing values to end of table
If selected missing values are always placed at the end of the sorted output. This is independent of the sort order, i.e. if sorted ascendingly they are considered to be larger than a non-missing value and if sorted descendingly they are smaller than any non-missing value.
Sort in memory
If selected the table is sorted in memory which requires more memory, but is faster. In case the input table is large and memory is scarce it is recommended not to check this option.

Input Ports

Icon
Table to be sorted.

Output Ports

Icon
A sorted table.

Popular Predecessors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.