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 Predecessors
- Keras Network Executor7 %
CSV Reader5 %File Reader4 %Excel Reader (XLS)4 %Column Appender3 %- Joiner2 %
- CSV Reader2 %
- Column Comparator2 %
Cell Splitter2 %DL Network Executor2 %- Many to One1 %
- String Manipulation (Multi Column)1 %
Number To String1 %- Column Splitter1 %
- Rule-based Row Filter1 %
- Create Collection Column1 %
- Split Collection Column1 %
- String to Date&Time1 %
- String Manipulation (Variable)1 %
- Table Creator1 %
String To Number1 %- One to Many1 %
- Pivot1 %
- Data Generator1 %
Excel Reader (XLS)1 %- Column Filter< 1 %
Row Filter (deprecated)< 1 %- String Manipulation< 1 %
- Cross Joiner< 1 %
- Numeric Binner< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- String to Number< 1 %
- Column Resorter< 1 %
- Loop End (Column Append)< 1 %
- Column Appender< 1 %
- PCA Apply< 1 %
Database Reader< 1 %- k-Means< 1 %
- Concatenate< 1 %
- Column Name Extractor< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
Row Splitter (deprecated)< 1 %- GroupBy< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
Column Rename< 1 %- Rule Engine< 1 %
- DL Python Network Executor< 1 %
Excel Reader (XLS)< 1 %- JSON to Table< 1 %
- Cell Splitter< 1 %
- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Value Counter< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Duplicate Row Filter< 1 %
- Table Manipulator< 1 %
- Data Explorer< 1 %
- TensorFlow 2 Network Executor< 1 %
- Excel Reader< 1 %
- Column Auto Type Cast< 1 %
- Group Loop Start< 1 %
- Column Renamer< 1 %
- Reference Row Filter< 1 %
- Date&Time Difference< 1 %
- SMOTE< 1 %
- Interactive Histogram (legacy)< 1 %
- Column Filter Configuration< 1 %
Database Connection Table Reader< 1 %- Column List Loop Start< 1 %
Concatenate (Optional in)< 1 %- Column Combiner< 1 %
- Double to Integer< 1 %
- Column Renamer (Dictionary)< 1 %
- R Snippet< 1 %
Cell Replacer< 1 %- Multiple Selection Widget< 1 %
- Column Aggregator< 1 %
- Normalizer< 1 %
- Statistics< 1 %
- Java Snippet (simple)< 1 %
- Table Validator< 1 %
- Constant Value Column Filter< 1 %
- Many to One (PMML)< 1 %
- Number Rounder< 1 %
- Color Manager< 1 %
- DB Reader< 1 %
- Mahalanobis Distance< 1 %
- TensorFlow Network Executor< 1 %
- XGBoost Predictor (Regression)< 1 %
- Discretise< 1 %
- RDKit Count-Based Fingerprint< 1 %
- Row Filter (Labs)< 1 %
- RDKit Descriptor Calculation< 1 %
Table Reader< 1 %- Java Snippet< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
- Category to Number< 1 %
- Constant Value Column< 1 %
- Domain Calculator< 1 %
Joiner< 1 %- RowID< 1 %
- Sorter< 1 %
- SDF Reader< 1 %
- One Row to Many< 1 %
- Distance Matrix Calculate< 1 %
- Column Expressions< 1 %
XLS Reader< 1 %- Topic Extractor (Parallel LDA)< 1 %
- JPMML Classifier< 1 %
Python Script (1⇒1)< 1 %- Strings to Binary Objects< 1 %
Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %- X-Aggregator< 1 %
Naive Bayes Predictor< 1 %- Naive Bayes Predictor< 1 %
- PNN Predictor< 1 %
- Decision Tree Predictor< 1 %
- K Nearest Neighbor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Linear Regression Learner< 1 %
- Regression Predictor< 1 %
Scorer< 1 %Tree Ensemble Learner (Regression)< 1 %- Random Forest Predictor< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Create Bit Vector< 1 %
- Number to Category (Apply)< 1 %
- Number to String< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- One to Many (PMML)< 1 %
- Missing Value (Apply)< 1 %
Number To String (PMML)< 1 %- Rank< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- Unpivot< 1 %
- Independent groups t-test< 1 %
- Cache< 1 %
- Extract Color< 1 %
- DB Query Reader< 1 %
- Similarity Search< 1 %
- PMML to Cell< 1 %
- Java Snippet Row Splitter< 1 %
- Snowball Stemmer< 1 %
- Column Filter (legacy)< 1 %
Extract Date&Time Fields< 1 %- Time Difference (legacy)< 1 %
- XPath< 1 %
- File Reader< 1 %
- Silhouette Coefficient< 1 %
- Scorer< 1 %
- Cell Splitter By Position< 1 %
Parquet Reader< 1 %- Heatmap (JavaScript)< 1 %
- Date&Time Part Extractor< 1 %
- Moving Average< 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.