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

Add sorting criterion

Allows to refine the sorting by adding additional sorting criteria.

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.

Move Missing Cells to end of sorted list

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.

Views

This node has no views

Workflows

• _01_Network_Traffic_ReportingKNIME Hub
• _01_PMR_AnalysisKNIME Hub
• 00 Data GenerationKNIME Hub
• 00 Main MenuKNIME Hub
• 00 Main MenuKNIME Hub
• Show all 2875 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
• Show all 8 links

Developers