Icon

Sorter

Some analytic processes require data to be sorted in some particular order. The Sorter node takes the rows of an input table and sorts them in ascending or descending order based on one or more column selections.

If multiple columns are selected in the configuration menu the data will be sorted by the values in topmost column and then sequentially moving downward.

The setting "Alphanumeric string comparison" is useful when you want to sort strings that have numeric values. For example, if you wish to sort the table by ROWKEY, leaving the option turned on will place "Row2" before "Row10." With this option turned off, "Row10" would come before "Row2."

Sorter Some analytic processes require data to be sorted in some particular order. The Sorternode takes the rows of an input table and sorts them in ascending or descending orderbased on one or more column selections.If multiple columns are selected in the configuration menu the data will be sorted by thevalues in topmost column and then sequentially moving downward.The setting "Alphanumeric string comparison" is useful when you want to sort stringsthat have numeric values. For example, if you wish to sort the table by ROWKEY,leaving the option turned on will place "Row2" before "Row10." With this option turnedoff, "Row10" would come before "Row2." Sorting by a single numeric column in ascendingorder will place the smallest numeric values at thetop of the table and the largest numeric values at thebottom of the table. Night Heron Data, 2023 Sorting by multiple columns is called a nested sort.Here, we sorted Country, Region, and StateName allin ascending order. This means that all Countryvalues are sorted first. Then, within each Countryvalue, each Region value is sorted. Finally, eachStateName value is sorted within each Region withineach Country. Sort by ROWKEY in ascending order with thealphanumeric string comparison turned ON. Thistreats numbers within strings as numbers and givesthe same kind of sort as if you sorted a numeric field. Sort by ROWKEY in ascending order with thealphanumeric string comparison turned OFF. Thistreats numbers as strings. Therefore, all numbersthat start with a 1 will come before all strings with a 2,and so on. Pay attention to the ID column in the toolto the left. Input some dataSort by a single columnSort by multiple stringcolumnsAlphanumericcomparison ONAlphanumericcomparison OFF Table Creator Sorter Sorter Sorter Sorter Sorter Some analytic processes require data to be sorted in some particular order. The Sorternode takes the rows of an input table and sorts them in ascending or descending orderbased on one or more column selections.If multiple columns are selected in the configuration menu the data will be sorted by thevalues in topmost column and then sequentially moving downward.The setting "Alphanumeric string comparison" is useful when you want to sort stringsthat have numeric values. For example, if you wish to sort the table by ROWKEY,leaving the option turned on will place "Row2" before "Row10." With this option turnedoff, "Row10" would come before "Row2." Sorting by a single numeric column in ascendingorder will place the smallest numeric values at thetop of the table and the largest numeric values at thebottom of the table. Night Heron Data, 2023 Sorting by multiple columns is called a nested sort.Here, we sorted Country, Region, and StateName allin ascending order. This means that all Countryvalues are sorted first. Then, within each Countryvalue, each Region value is sorted. Finally, eachStateName value is sorted within each Region withineach Country. Sort by ROWKEY in ascending order with thealphanumeric string comparison turned ON. Thistreats numbers within strings as numbers and givesthe same kind of sort as if you sorted a numeric field. Sort by ROWKEY in ascending order with thealphanumeric string comparison turned OFF. Thistreats numbers as strings. Therefore, all numbersthat start with a 1 will come before all strings with a 2,and so on. Pay attention to the ID column in the toolto the left. Input some dataSort by a single columnSort by multiple stringcolumnsAlphanumericcomparison ONAlphanumericcomparison OFF Table Creator Sorter Sorter Sorter Sorter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-06-02
On NodePit since: 2023-06-03
Last update: 2024-05-03
Created with KNIME version: v4.7.2
Tags: sortersortrow sortnode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!