Allows to perform several column transformations on any number of input tables such
as renaming, filtering, re-ordering and type changing of the input columns.
If more than one input table is available the node concatenates all input rows into a single result table. If the input tables contain the same RowID the node can either generate a new RowID or prepend the input table index to the original RowID of the corresponding input table.
Options
Popular Successors
- Concatenate9 %
- Excel Writer8 %
- GroupBy6 %
- Column Expressions4 %
- Row Filter4 %
- CSV Writer4 %
- String Manipulation3 %
- Sorter3 %
- Duplicate Row Filter2 %
- Math Formula2 %
- Rule Engine2 %
- Rule-based Row Filter2 %
- Table Manipulator2 %
- Missing Value2 %
- Constant Value Column2 %
- Column Filter2 %
- DB Writer1 %
- Row Splitter1 %
- Column Resorter1 %
- String to Date&Time1 %
- Cell Splitter< 1 %
Column Rename< 1 %- DB Insert< 1 %
- Pivot< 1 %
- Loop End< 1 %
- Rule-based Row Splitter< 1 %
- String to Number< 1 %
- String Manipulation (Multi Column)< 1 %
- Cross Joiner< 1 %
Cell Replacer< 1 %- Column Appender< 1 %
- Table Writer< 1 %
- Partitioning< 1 %
- Table Transposer< 1 %
- Column Combiner< 1 %
- Unpivot< 1 %
- Extract Date&Time Fields< 1 %
- Number to String< 1 %
- Math Formula (Multi Column)< 1 %
- Nominal Value Row Filter< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Difference< 1 %
- End IF< 1 %
- Round Double< 1 %
- Date&Time to String< 1 %
- RowID< 1 %
- Reference Row Filter< 1 %
- DB Loader< 1 %
- String Replacer< 1 %
- Send to Tableau Server< 1 %
- Group Loop Start< 1 %
- Table View< 1 %
- Table Validator< 1 %
- Column Merger< 1 %
- Row Filter (Labs)< 1 %
- Color Manager< 1 %
- Column Aggregator< 1 %
- Parquet Writer< 1 %
- Normalizer< 1 %
- Table Difference Finder< 1 %
- Tableau Writer< 1 %
- Row Splitter (Labs)< 1 %
- XLS Control Table Generator< 1 %
- DB Merge< 1 %
- Data to Report (BIRT)< 1 %
- Java Snippet< 1 %
- Rank< 1 %
- Extract Table Spec< 1 %
- Column Renamer< 1 %
- Column Auto Type Cast< 1 %
- Ungroup< 1 %
- Column Splitter< 1 %
- Modify Time< 1 %
- Bar Chart< 1 %
- Statistics< 1 %
- Value Lookup< 1 %
- Table Validator (Reference)< 1 %
- DB Update< 1 %
- Regex Split< 1 %
- Table Row to Variable Loop Start< 1 %
- String Replacer (Dictionary)< 1 %
- DB Table Creator< 1 %
- Recursive Loop Start< 1 %
- Data Explorer< 1 %
- Variable to Table Column< 1 %
- SDF Writer< 1 %
- Table to JSON< 1 %
- Table Row to Variable< 1 %
- Chunk Loop Start< 1 %
- Nominal Value Row Splitter< 1 %
- Value Counter< 1 %
- Missing Value Column Filter< 1 %
- Google Sheets Updater< 1 %
- CASE Switch Start< 1 %
- Column Comparator< 1 %
- Column Rename (Regex)< 1 %
- Empty Table Switch< 1 %
- Case Converter< 1 %
- Reference Column Filter< 1 %
- Send to Power BI< 1 %
- Date&Time Shift< 1 %
- Molecule Type Cast< 1 %
- GET Request< 1 %
- Modify Date< 1 %
- String to Date/Time (legacy)< 1 %
- Table to HTML String< 1 %
- Add Empty Rows< 1 %
DB Table Creator< 1 %- Counter Generation< 1 %
- Java Snippet (simple)< 1 %
- Python Script (legacy)< 1 %
- Table Column to Variable< 1 %
- Lag Column< 1 %
- Google Sheets Writer< 1 %
- Recursive Loop End< 1 %
- Numeric Binner< 1 %
- Cell Splitter By Position< 1 %
- Category to Number< 1 %
- Linear Correlation< 1 %
- Domain Calculator< 1 %
- Interactive Table (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Bar Chart (JavaScript)< 1 %
- Linear Regression Learner< 1 %
- One to Many< 1 %
- Filter Apply< 1 %
- Similarity Search< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Excel Cell Updater< 1 %
- Create Collection Column< 1 %
- X-Partitioner< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Reference Column Resorter< 1 %
- CASE Switch End< 1 %
- Column List Loop Start< 1 %
- k-Means< 1 %
- Auto-Binner< 1 %
- Joiner< 1 %
- Rule Engine (Dictionary)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Split Collection Column< 1 %
- Decision Tree Learner< 1 %
- Missing Value (Apply)< 1 %
- Rank Correlation< 1 %
- Extract Table Dimension< 1 %
- Dictionary Tagger< 1 %
- Path to String< 1 %
- Modify Time Zone< 1 %
- Object Inserter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Loop End (Column Append)< 1 %
- Send Email< 1 %
- RDKit From Molecule< 1 %
- R Snippet< 1 %
- Scorer (JavaScript)< 1 %
- MySQL Connector< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- String to Duration< 1 %
- Write To Excel Template (deprecated)< 1 %
CSV Writer< 1 %- Cluster Assigner< 1 %
- Edit Nominal Domain< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
String Replace (Dictionary)< 1 %- IF Switch< 1 %
- Interactive Value Filter Widget< 1 %
- R View (Table)< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Nominal Row Filter Configuration< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Scatter Plot (Plotly)< 1 %
- Collection to String< 1 %
- Sunburst Chart< 1 %
Database Update< 1 %- Column to Grid< 1 %
- Filter Apply Row Splitter< 1 %
- DB Delete (Table)< 1 %
- Value Selection Configuration< 1 %
- Column Selection Widget< 1 %
- Value Selection Widget< 1 %
- Workflow Service Output< 1 %
- XPath< 1 %
- RDKit Descriptor Calculation< 1 %
- File Splitter for Cluster< 1 %
- Table To Excel Cell Updater< 1 %
- Create Byte Vector< 1 %
- SQLite Connector< 1 %
- Cell Updater< 1 %
- Table Splitter< 1 %
- Line Plot< 1 %
- SMB Connector< 1 %
- Catch Errors (Data Ports)< 1 %
- Image Writer (Table)< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
Joiner< 1 %- Row Sampling< 1 %
- Top k Row Filter< 1 %
- DB SQL Executor< 1 %
- One Row to Many< 1 %
- Table to PDF (legacy)< 1 %
Excel Writer (XLS)< 1 %Send to Power BI< 1 %- String Matcher< 1 %
- String to Path< 1 %
- Line Plot (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Multipart Encoded HTTP Entity Creator< 1 %
- Webpage Retriever< 1 %
- ARFF Writer< 1 %
- XML Column Combiner< 1 %
- DB Looping< 1 %
- Table to Image< 1 %
Table Writer< 1 %Loop End (2 ports)< 1 %- Naive Bayes Learner< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Regression Predictor< 1 %
- SVM Learner< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Edit Numeric Domain< 1 %
- Interactive HiLite Collector< 1 %
- Cache< 1 %
- Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Capture Workflow End< 1 %
- Keras Network Learner< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Strings to Document< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- String to JSON< 1 %
- Columns to JSON< 1 %
- Python View (legacy)< 1 %
- Table Difference Checker< 1 %
- RDKit Canon SMILES< 1 %
RDKit Functional Group Filter< 1 %Regex Extractor< 1 %- String to XML< 1 %
- Row to Column Names< 1 %
- Microsoft SQL Server Connector< 1 %
- String to SVG< 1 %
- XLS Row and Column Sizer< 1 %
- Java IF (Table)< 1 %
- RProp MLP Learner< 1 %
- Regex Extractor< 1 %
- Parallel Chunk End< 1 %
- Inject Column Properties< 1 %
- Row Aggregator< 1 %
- Plate Heatmap Viewer< 1 %
- Try (Data Ports)< 1 %
- Variable to Table Row< 1 %
Loop End< 1 %- Counting Loop Start< 1 %
- Variable Loop End< 1 %
- Logistic Regression Learner< 1 %
- Scorer< 1 %
- SMOTE< 1 %
- SOTA Learner< 1 %
- Association Rule Learner< 1 %
- Random Forest Learner< 1 %
- Random Forest Predictor< 1 %
- Binner (Dictionary)< 1 %
- Expand Bit Vector< 1 %
- Number to Category (Apply)< 1 %
- Many to One< 1 %
- Double to Integer< 1 %
- Reference Column Splitter< 1 %
- Subset Matcher< 1 %
- Numeric Row Splitter< 1 %
- Set Operator< 1 %
- Shuffle< 1 %
- Numeric Outliers< 1 %
- Independent groups t-test< 1 %
CASE Switch Data (Start)< 1 %- Timer Info< 1 %
- Interactive Histogram (legacy)< 1 %
Color Appender< 1 %Parquet Writer< 1 %- PMML Predictor< 1 %
- Stop Word Filter< 1 %
- Files/Folders Meta Info< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Container Output (Table)< 1 %
- Table to R< 1 %
Extract Date&Time Fields< 1 %- Molecule to CDK< 1 %
Call Workflow Service< 1 %- External Tool< 1 %
- Create Date&Time Range< 1 %
- Python Predictor (legacy)< 1 %
- Java Distance< 1 %
- Create Table Structure< 1 %
- Nominal Probability Distribution Creator< 1 %
- Value Filter (legacy)< 1 %
- Numeric Scorer< 1 %
- Number to String (PMML)< 1 %
- RDKit To Molecule< 1 %
- Neo4j Writer< 1 %
- 2D/3D Scatterplot< 1 %
- BERT Classification Learner< 1 %
- Feature Table To List< 1 %
- Mountpoint Connector< 1 %
- Radar Plot Appender< 1 %
- RDKit Molecule Catalog Filter< 1 %
- Wait...< 1 %
- String Widget< 1 %
- Generic Loop Start< 1 %
- PCA< 1 %
- Scatter Plot< 1 %
- Statistics View< 1 %
- Oracle Connector< 1 %
- RDKit Molecule to SVG< 1 %
- Python Snippet< 1 %
- XLS Coloured Writer< 1 %
Database Writer< 1 %- Silhouette Coefficient< 1 %
- Equal Size Sampling< 1 %
- Denormalizer< 1 %
- Crosstab< 1 %
- Pie chart (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Distance Matrix Calculate< 1 %
- Math Formula (Variable)< 1 %
- Interval Chart (JFreeChart)< 1 %
- OpenNLP NE Tagger< 1 %
- Container Output (JSON)< 1 %
- POST Request< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Two Component Reaction< 1 %
- Extract Properties< 1 %
- List To Set< 1 %
- Number Formatter< 1 %
- Normalize Plates (NPI)< 1 %
- MolConverter< 1 %
Counting Loop Start< 1 %- Hierarchical Cluster Assigner< 1 %
- Create Bit Vector< 1 %
- Correlation Filter< 1 %
CASE Switch Data (End)< 1 %- Scatter Plot (legacy)< 1 %
- Autocomplete Text Widget< 1 %
- Cell to PMML< 1 %
- OSM Map View< 1 %
- DF< 1 %
- Document Viewer< 1 %
- Text Output Widget (legacy)< 1 %
- JSON Column Combiner< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Molecular Properties< 1 %
Reverse Location Lookup< 1 %- String-to-Type< 1 %
- Matlab Snippet< 1 %
- Structures Overview Retriever< 1 %
- PNGs to Binary Objects< 1 %
Recursive Loop Start< 1 %Table Row To Variable Loop Start< 1 %- Simple Regression Tree Predictor< 1 %
- Shape Manager< 1 %
- Size Manager< 1 %
- Parallel Chunk End (multi port)< 1 %
- Conditional Label Assigner< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Table to H2O< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- NGram Creator< 1 %
- Replacer< 1 %
- Abner Tagger< 1 %
- POS Tagger< 1 %
- Delete Files/Folders< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Appender< 1 %
- Lift Chart (JavaScript)< 1 %
- File Upload Widget< 1 %
- Image Viewer< 1 %
- Parameter Optimization Loop Start< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
Python Script (1⇒1)< 1 %- Remove Empty Rows< 1 %
- RDKit Generate Coords< 1 %
- RDKit To InChI< 1 %
- Geo Distances< 1 %
Write MDB< 1 %- XLS Background Colorizer< 1 %
- XLS Font Formatter< 1 %
- XLS Control Table from Cell Range< 1 %
- Standardizer< 1 %
- LigPrep< 1 %
- Lookup and Add Columns< 1 %
- PLS Model Building< 1 %
- Set Molecule Title< 1 %
- Similarity Matrix (from Molecules)< 1 %
- Correlation Matrix To Pairs< 1 %
- TIBCO Spotfire File Writer< 1 %
- Set To List< 1 %
- HLB< 1 %
- ARIMA Learner< 1 %
- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
- Upload (legacy)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Read Images< 1 %
- Table Reader< 1 %
- Feature Selection Filter< 1 %
Interval Loop Start< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %Recursive Loop Start (2 ports)< 1 %- Fuzzy Rule Predictor< 1 %
- Hierarchical Cluster View< 1 %
- DBSCAN< 1 %
- Decision Tree to Image< 1 %
- Logistic Regression Predictor< 1 %
- Gradient Boosted Trees Learner< 1 %
- Tree Ensemble Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Perl Scripting< 1 %
- Auto-Binner (Apply)< 1 %
- Bootstrap Sampling< 1 %
- Category to Number (Apply)< 1 %
- Extract Missing Value Cause< 1 %
- Normalizer (Apply)< 1 %
- One to Many (PMML)< 1 %
- String to Number (PMML)< 1 %
- Renderer to Image< 1 %
- Ruleset Editor< 1 %
- Shapiro-Wilk Test< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Linear Discriminant Analysis< 1 %
- Conditional Box Plot (legacy)< 1 %
- HiLite Table (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- DB Connector< 1 %
- Parameterized DB Query Reader< 1 %
- Random Number Assigner< 1 %
- Numeric Distances< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- Error Bars Plot (Plotly)< 1 %
- Boosting Learner Loop Start< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- LIBSVMLearner< 1 %
- External SSH Tool< 1 %
- Term Co-Occurrence Counter< 1 %
- Tika Language Detector< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer< 1 %
- Number Filter< 1 %
- Meta Info Extractor< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders (Table)< 1 %
- Path to URI< 1 %
Google Authenticator (API Key)< 1 %- Column Filter (legacy)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Column Filter Widget< 1 %
- Kafka Producer< 1 %
- Image Properties< 1 %
- Duration to Number< 1 %
- Date&Time to legacy Date&Time< 1 %
- Extract Duration Fields< 1 %
XGBoost Linear Ensemble Learner< 1 %- CDK to Molecule< 1 %
- RDKit Interactive Table< 1 %
- RDKit SMILES Headers< 1 %
- HTTP Retriever< 1 %
Views
- This node has no views
Workflows
0. Lubes_Sales_Pred-ModelNodePit Space- 0. Lubes_Sales_Pred-ModelNodePit Space
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 714 workflows
Links
- Unsupported Column Type - String V. Databy HansS on 2021-06-22forum.knime.com/p/127223
- Componente para mapeo de camposby jmgor on 2022-01-02forum.knime.com/p/143267
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.