Hub
NodeNode / Manipulator

DB Sorter

DB Query
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: DB Data
    DB Data to sort
    DB Data to apply sorter.
Output ports
  1. Type: DB Data
    Sorted DB Data
    DB Data with sorted rows.

Extension

The DB Sorter node is part of this extension:

Related workflows & nodes

  1. Basic RESTful Web Services Example 1
    Demonstrates how to create a REST-based web service that can be deployed via the KNIME Se…
    knime > Examples > 09_Enterprise > 01_Server > 01_RESTful_Services > 01_Create_basic_service
    knime
  2. 01_Flight_Delay_Statistics
    tobias.koetter > Public > Big_Data_Workshop_2020 > 01_Flight_Delay_Statistics
    tobias.koetter
  3. 01_Flight_Delay_Statistics_Impala
    bjoern.lohrmann > Public > Big_Data_Workshop_2020 > 01_Flight_Delay_Statistics_Impala
    bjoern.lohrmann
  4. DB_vs_KNIME
    Database H2 Database preprocessing
    Comparing data processing with DB nodes vs KNIME nodes.
    hayasaka > Public > DB_vs_KNIME
    hayasaka
  5. Big Data preprocessing
    Hive Hadoop Big Data
    +2
    This workflow demonstrates the usage of the DB nodes in conjunction with the Create Local…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 2_Hadoop > 4_Examples > 01_Big_Data_Preprocessing_Example
    knime
  6. 02 DB InDB Processing Exercise Solution
    Big Data Education
    Big Data Course DB Exercise #2 Solution
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 3_Solutions > 02_DB_InDB_Processing
    knime
  7. Big Data preprocessing
    Hive Hadoop Big Data
    +2
    This workflow demonstrates the usage of the DB nodes in conjunction with the Create Local…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example
    knime
  8. Getting Data from a Database
    tosinlitics > Public > Getting Data from a Database
    tosinlitics
  9. Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    deganza > Public > KNIME_Solutions_for_real_applications > c2.1_Data_Access_with_KNIME_SQL_and_Co > Data Access - 03 Databases example
    deganza
  10. Fetch ChEMBL Target Data Meta Information
    Jupyter Python Topic modeling
    +3
    This workflow uses a query against a SQL version of the ChEMBL database to retrieve a bun…
    knime > Examples > 07_Scripting > 03_Python > 03_Fetch_ChEMBL_Target_Data
    knime