NodeNode / Manipulator

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.

Input ports
  1. DB Data to sort Type: DB Data
    DB Data to apply sorter.
Output ports
  1. Sorted DB Data Type: DB Data
    DB Data with sorted rows.
  1. demonstrates the use of DB Update and DB Merge
    demonstrates the use of DB Update and DB Merge
    mlauber71 > Public > kn_example_db_update_merge
  2. demonstrates the use of DB Update and DB Merge with MS Access DB
    ms access sql +5
    demonstrates the use of DB Update and DB Merge with MS Access DB
    mlauber71 > Public > kn_example_db_update_merge_ms_access
  3. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
  4. 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 bunch of information about user-p…
    knime > Examples > 07_Scripting > 03_Python > 03_Fetch_ChEMBL_Target_Data
  5. 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
  6. Send data to tableau server example
    Tableau
    This workflow reads the data of the last 24 hours from a database and sends it to a tableau server. If the workflow is …
    kathrin > Public > Forum_Question_Tableau_Example > Send_Data_to_Tableau_Server
  7. Big Data preprocessing
    Hive Hadoop Big Data +2
    This workflow demonstrates the usage of the DB nodes in conjunction with the Create Local Big Data Environment node, wh…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example
  8. DB_vs_KNIME
    database H2 database preprocessing
    Comparing data processing with DB nodes vs KNIME nodes.
    hayasaka > Public > DB_vs_KNIME
  9. Basic RESTful Web Services Example 1
    Demonstrates how to create a REST-based web service that can be deployed via the KNIME Server.
    knime > Examples > 09_Enterprise > 01_Server > 01_RESTful_Services > 01_Create_basic_service
  10. 01_Flight_Delay_Statistics_Impala
    bjoern.lohrmann > Public > Big_Data_Workshop_2020 > 01_Flight_Delay_Statistics_Impala