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.

Views

This node has no views

Workflows

• Credit Scoring Model(diksha kumari)KNIME Hub
• _01_Network_Traffic_ReportingKNIME Hub
• _01_PMR_AnalysisKNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflowKNIME Hub
• Show all 5323 workflows

Links

• Set an individual row order / Sort after Month Nameby AnotherFraudUser on 2020-05-25

  forum.knime.com/p/92286
• question in knimeby izaychik63 on 2019-03-10

  forum.knime.com/p/55897
• Deal with odd & even rows separatelyby armingrudd on 2019-10-08

  forum.knime.com/p/71856
• Sort X Labelby armingrudd on 2019-12-16

  forum.knime.com/p/77132
• Dealing with Monthly and quarterly datasby knimediger on 2019-10-31

  forum.knime.com/p/73738
• Flag Row according to conditionalby izaychik63 on 2019-06-07

  forum.knime.com/p/61850
• How to organize superseded row databy armingrudd on 2019-12-17

  forum.knime.com/p/77226
• Missing values working wrongby ipazin on 2022-12-12

  forum.knime.com/p/182706

Developers