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

Column Aggregator

Manipulation Column Split & Combine Streamable
Drag & drop
Like
Copy short link

Groups the selected columns per row and aggregates their cells using the selected aggregation method.

To change the name of the new created aggregation column double click on the name column.

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: Table
    Data table
    The input table to aggregate.
Output ports
  1. Type: Table
    Table with aggregation columns
    Result table with the aggregation columns per row.

Extension

The Column Aggregator node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Remove Duplicatess from cell with comma separated values
    Remove Duplicatess from cell with comma separated values
    mlauber71 > Public > forum > kn_forum_fb_remove_cell_duplicatess
  2. Go to item
    All in One Row
    One Row Data Manipulation
    This workflow transforms input table with n rows and m columns to 1 row and n times m col…
    ipazin > Public > 2019_09_05_All_in_One_Row
  3. Go to item
    Convert words with 3 or less characters to uppercase
    Convert words with 3 or less characters to uppercase
    bruno29a > Public > Forum > Convert words with 3 or less characters to uppercase
  4. Go to item
    Signal Processing
    corey > Public > Signal Processing
  5. Go to item
    Multiple Set Means
    Data Manipulation
    This workflow uses Cross Joiner node to combine 3 table with different tags (IDs) and the…
    ipazin > Public > 2019_09_05_Multiple_Set_Means
  6. Go to item
    Sum last 3 non zeros in a row
    Here I got 1 table where i got the following 1 5 4 7 8 3 0 7 0 8 0 2 I want to sum only t…
    bruno29a > Public > Forum > Sum last 3 non zeros in a row
  7. Go to item
    Working With Collections - Collection creation and conversion
    ETL Collections Column Aggregator
    The goal of the workflow is to demonstrate the creation and working with collection cells…
    knime > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 01_Working_with_Collection_Creation_and_Conversion
  8. Go to item
    Getting Name of Max Column
    ana_ved > Public > Getting Name of Max Column
  9. Go to item
    Transform Data Tables by Removing all Empty Cells in a Row
    kathrin > Forum Questions > Transform Data Tables by Removing all Empty Cells in a Row
  10. Go to item
    Find_terms_in_text
    ana_ved > Public > Find_terms_in_text
  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