Hub
Pricing About
NodeNode / Manipulator

Many to One

ManipulationColumnTransform
Drag & drop
Like

Aggregates several columns into one single column.
In each row, it finds a matching column from the set of selected columns and places the name of that matching column into the aggregated result column. Which column matches depends on the selected "include method" and the include pattern.
If no column matches a missing value is added. If multiple columns match execution fails and no output is generated.
Missing values in the selected columns are ignored. If all selected columns of one row consist of missing values a missing value is put in the aggregated column. All include methods except the regular expression require columns which are double compatible.

Node details

Input ports
  1. Type: Table
    Data to process
    Data
Output ports
  1. Type: Table
    Processed data
    Data with aggregated column

Extension

The Many to One node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits