Hub
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:

Related workflows & nodes

  1. 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. 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. 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. Signal Processing
    corey > Public > Signal Processing
  5. 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. 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. 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. Getting Name of Max Column
    ana_ved > Public > Getting Name of Max Column
  9. 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. Find_terms_in_text
    ana_ved > Public > Find_terms_in_text