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

GroupBy

Manipulation Row Transform
Drag & drop
Like
Copy short link

Groups the rows of a table by the unique values in the selected group columns. A row is created for each unique set of values of the selected group column. The remaining columns are aggregated based on the specified aggregation settings. The output table contains one row for each unique value combination of the selected group columns.

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.

External resources

  • KNIME E-Learning Course: Classic Aggregations with GroupBy node

Node details

Input ports
  1. Type: Table
    Data table
    The input table to group.
Output ports
  1. Type: Table
    Group table
    Result table with one row for each existing value combination of the selected columns.

Extension

The GroupBy node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    50143
    stelfrich > Forum > 50143
  2. Go to item
    06 - Project 1 - Aggregations
    armourbl > Public > 4015C - Project 1 > Lab 1 - Workflow > 06 - Project 1 - Aggregations
  3. Go to item
    06 - Project 1 - Aggregations
    armourbl > 4015C - Project 1 > Lab 1 - Workflow > 06 - Project 1 - Aggregations
  4. Go to item
    6
    lina3 > Public > Lab 3 > 6
  5. Go to item
    concatenate
    elsamuel > Public > Concatenate Excel Tables > concatenate
  6. Go to item
    Flow Vairbales
    apugh734 > Public > Lesson 2 PArt 2 > Flow Vairbales
  7. Go to item
    Data Manipulation 2
    baileke > IT 4015 Baileke Projects > Final Project > Excercises > Data Manipulation 2
  8. Go to item
    Lab 1 - 06 - Aggregations
    the32bitphoenix > Public > Lab 1 - Additional Examples > Lab 1 - 06 - Aggregations
  9. Go to item
    Data Manipulation 2
    doctorbrunson > Final Project > Final Project > Excercises > Data Manipulation 2
  10. Go to item
    10 Write Data to a File - Solution
    Export Csv
    Solution to an exercise for exporting data. Aggregate data and write the results into a C…
    knime > Education > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 10 Write Data to a File - Solution
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 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 Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits