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.
Options
Popular Successors
- Many to One5 %
- Chunk Loop Start4 %
- Scorer4 %
- Color Manager3 %
Row Filter (deprecated)3 %- String Manipulation3 %
- Loop End (Column Append)2 %
String To Number2 %- Data Explorer2 %
- SMOTE2 %
- Column Filter2 %
Number To String2 %Joiner2 %- Split Collection Column1 %
- One to Many1 %
- Missing Value1 %
- Excel Writer1 %
Cell Replacer1 %- Number to String1 %
- Pivot1 %
- Math Formula1 %
- CSV Writer1 %
- X-Partitioner1 %
- GroupBy1 %
- Joiner1 %
- Normalizer1 %
- Partitioning1 %
- Create Collection Column< 1 %
- Cell Splitter< 1 %
- Column Comparator< 1 %
- String to Number< 1 %
- Table Manipulator< 1 %
Column Rename< 1 %- Set Operator< 1 %
- Value Counter< 1 %
- Rule Engine< 1 %
- Statistics< 1 %
- Crosstab< 1 %
- Bar Chart< 1 %
- Column Expressions< 1 %
XLS Writer< 1 %- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Numeric Binner< 1 %
Column Appender< 1 %- Reference Column Filter< 1 %
- Subset Matcher< 1 %
- Denormalizer< 1 %
- String Splitter (Regex)< 1 %
- Ungroup< 1 %
- JSON Column Combiner< 1 %
- R Snippet< 1 %
Table Writer< 1 %- Group Loop Start< 1 %
- Decision Tree Learner< 1 %
- Column Resorter< 1 %
Row Splitter (deprecated)< 1 %- Many to One (PMML)< 1 %
- Bar Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Database Writer< 1 %- Java Snippet< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Auto-Binner< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
- Rank< 1 %
- Sorter< 1 %
- Interactive Histogram (legacy)< 1 %
- ROC Curve (legacy)< 1 %
Excel Writer (XLS)< 1 %- Scorer (JavaScript)< 1 %
JSON Writer< 1 %Python Script (1⇒1)< 1 %- Table Difference Checker< 1 %
- Google Address Geocoder< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %- Table Row to Variable< 1 %
CSV Writer< 1 %- Loop End< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
- X-Aggregator< 1 %
- Cluster Assigner< 1 %
- Silhouette Coefficient< 1 %
- Fuzzy c-Means< 1 %
- k-Means< 1 %
- Decision Tree Predictor< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
Scorer< 1 %- Association Rule Learner< 1 %
- SVM Predictor< 1 %
Tree Ensemble Predictor< 1 %- Tree Ensemble Predictor (Regression)< 1 %
Random Forest Learner< 1 %- Add Empty Rows< 1 %
- Concatenate< 1 %
Concatenate (Optional in)< 1 %- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Case Converter< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Constant Value Column< 1 %
- Linear Correlation< 1 %
- Correlation Filter< 1 %
- Cross Joiner< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Edit Nominal Domain< 1 %
- Double to Integer< 1 %
- Constant Value Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Reference Column Resorter< 1 %
- RowID< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
Rank Correlation< 1 %- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Conditional Box Plot (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Loader< 1 %
- One Row to Many< 1 %
- Matrix Distance< 1 %
DL Network Executor< 1 %Table to HTML< 1 %- Math Formula (Multi Column)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Transfer Files (Table)< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- JSON to Table< 1 %
- Data Row to Image< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- String to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Column to XML< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00_Keras_Transfer_LearningKNIME Hub
- 00_Keras_Transfer_LearningKNIME Hub
- 01_AutoML_Component_via_Interactive_ViewsKNIME Hub
- Show all 208 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.