DB Sorter

This node sorts the DB Data 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.

Input Ports

: DB Data to apply sorter.

Output Ports

: DB Data with sorted rows.

Popular Predecessors

DB Row Filter42 %
DB Query19 %
DB Column Filter14 %
DB GroupBy4 %
DB Pivot3 %
Show all 18 recommendations

Popular Successors

DB Connection Table Writer38 %
DB Pivot13 %
DB Column Rename11 %
DB Reader7 %
DB Query Extractor5 %
Show all 18 recommendations

Views

This node has no views

Workflows

01_Big_Data_Preprocessing_ExampleKNIME Hub
01_Big_Data_Preprocessing_ExampleKNIME Hub
01_Create_basic_serviceKNIME Hub
01_Flight_Delay_StatisticsKNIME Hub
01_Flight_Delay_Statistics_ImpalaKNIME Hub
Show all 24 workflows

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.