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.

Options

Add columns

If you want to extend the sorting criteria to a higher number of columns as displayed, set the number of columns at the bottom and click 'new columns' to add them to the dialog.

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.

Input Ports

Table to be sorted.

Output Ports

A sorted table.

Best Friends (Incoming)

• GroupBy (13 %) 
• Joiner (6 %) 
• Concatenate (6 %) Streamable
• Row Filter (6 %) Streamable
• Column Filter (5 %) Streamable
• Show all 744 recommendations

Best Friends (Outgoing)

• Row Filter (9 %) Streamable
• GroupBy (8 %) 
• Joiner (5 %) 
• Column Filter (5 %) Streamable
• Math Formula (4 %) Streamable
• Show all 884 recommendations

Workflows

• _​01_​Network_​Traffic_​Reporting (KNIME Hub) 
• _​01_​PMR_​Analysis (KNIME Hub) 
• 00_​Guided_​Labeling_​for_​Document_​Classification_​(legacy) (KNIME Hub) 
• 00_​KNIME_​Workshop_​basics (KNIME Hub) 
• 01_​Accessing_​Transforming_​and_​Modeling_​Time_​Series (KNIME Hub) 
• Show all 742 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

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.