Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB GroupBy
NodeNode / Manipulator

DB GroupBy

DB Query
Drag & drop
Like
Copy short link

This node allows rows to be grouped by the selected columns from the input DB Data object. Within the dialog, an SQL GROUP BY clause is interactively created by selecting the columns to group by and the columns to aggregate.

The columns to aggregate can be either defined by selecting the columns directly, by name based on a search pattern or based on the data type. Input columns are handled in this order and only considered once e.g. columns that are added directly on the "Manual Aggregation" tab are ignored even if their name matches a search pattern on the "Pattern Based Aggregation" tab or their type matches a defined type on the "Type Based Aggregation" tab. The same holds for columns that are added based on a search pattern. They are ignored even if they match a criterion that has been defined in the "Type Based Aggregation" tab.

The "Manual Aggregation" tab allows you to change the aggregation method of more than one column. In order to do so select the columns to change, open the context menu with a right mouse click and select the aggregation method to use.

In the "Pattern Based Aggregation" tab you can assign aggregation methods to columns based on a search pattern. The pattern can be either a string with wildcards or a regular expression . Columns where the name matches the pattern but where the data type is not compatible with the selected aggregation method are ignored. Only columns that have not been selected as group column or that have not been selected as aggregation column on the "Manual Aggregation" tab are considered.

The "Type Based Aggregation" tab allows to select an aggregation method for all columns of a certain data type e.g. to compute the mean for all decimal columns (DoubleCell). Only columns that have not been handled by the other tabs e.g. group, column based and pattern based are considered. The data type list to choose from contains basic types e.g String, Double, etc. and all data types the current input table contains.

A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data to apply group by.
Output ports
  1. Type: DB Data
    Grouped DB Data
    DB Data with grouped rows.

Extension

The DB GroupBy node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Database Manipulation 2
    danielbg > Public > Database Manipulation 2
    danielbg
  2. Go to item
    02_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the databa…
    stervis > Public > E-Learning > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 02_Database_Data_Manipulation - Solution
    stervis
  3. Go to item
    15_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the databa…
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 15_Database_Data_Manipulation - Solution
    stervis
  4. Go to item
    Database Data Manipulation
    kzhqtt > Public > _WA_American-Time-Use-Survey > Database Data Manipulation
    kzhqtt
  5. Go to item
    データベースノード - DB Node
    Japanese 日本語 Makkynm
    +10
    DB Nodeの紹介用Workflowです。 MS Accessのテーブルを取り込む作業にも使用できます。 This workflow is to introduce DB No…
    makkynm > Public > Advanced > A101_DataBaseNode
    makkynm
  6. Go to item
    02 Database Data Manipulation
    Database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggreg…
    mcmas1999 > Assignments > Lab 04 > Project 4 - mickelma > Exercises > 02 Database Data Manipulation
    mcmas1999
  7. Go to item
    Lab 3.2
    doctorbrunson > Lab 3.2 > Lab 3.2
    doctorbrunson
  8. Go to item
    02_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the fi…
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    burdhasp
  9. Go to item
    02 Database Data Manipulation
    Database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggreg…
    elzamc > Public > MICAH ELZA L2-DS KNIME Analytics Platform for Data Scientists - Advanced > CUSTOM DATA > 02 Database Data Manipulation
    elzamc
  10. Go to item
    02_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the databa…
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 02_Database_Data_Manipulation - Solution
    burdhasp
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits