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 Predecessors
- Joiner8 %
- GroupBy5 %
Row Filter (deprecated)5 %- Column Expressions4 %
- Concatenate4 %
- Excel Reader4 %
- Math Formula3 %
- Table Manipulator3 %
- Column Filter3 %
- String Manipulation3 %
- Rule Engine3 %
- Rule-based Row Filter3 %
- Cell Splitter2 %
- CSV Reader2 %
- Duplicate Row Filter2 %
- Missing Value2 %
- Sorter2 %
Row Splitter (deprecated)2 %- Constant Value Column2 %
- String to Date&Time2 %
- Pivot1 %
- Rule-based Row Splitter1 %
Column Rename1 %- Unpivot1 %
- Column Resorter< 1 %
- Table Creator< 1 %
- String to Number< 1 %
- DB Query Reader< 1 %
- Cross Joiner< 1 %
- Column Appender< 1 %
- Loop End< 1 %
- String Manipulation (Multi Column)< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- File Reader< 1 %
- Excel Writer< 1 %
- Date&Time Difference< 1 %
- Table Reader< 1 %
- Math Formula (Multi Column)< 1 %
- Column Auto Type Cast< 1 %
- Number Rounder< 1 %
- Date&Time-based Row Filter< 1 %
- String Replacer< 1 %
- JSON to Table< 1 %
Cell Replacer< 1 %- Ungroup< 1 %
- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- RowID< 1 %
- Date&Time Shift< 1 %
- Google Sheets Reader< 1 %
- Date&Time to String< 1 %
- Date&Time Part Extractor< 1 %
- Empty Table Switch< 1 %
- DB Reader< 1 %
- Value Lookup< 1 %
- JSON Path< 1 %
- Reference Row Filter< 1 %
- Modify Time< 1 %
- String Splitter (Regex)< 1 %
- Python Source (legacy)< 1 %
- Group Loop Start< 1 %
- Table Transposer< 1 %
- Column Splitter< 1 %
- Counter Generation< 1 %
Loop End< 1 %Joiner< 1 %- Column to Grid< 1 %
- R Snippet< 1 %
- Cell Splitter By Position< 1 %
- Create Table Structure< 1 %
- Row Sampling< 1 %
- Twitter Search< 1 %
- XPath< 1 %
- RDKit Canon SMILES< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Case Converter< 1 %
- Column Rename (Regex)< 1 %
- Row Splitter (Labs)< 1 %
- CASE Switch Start< 1 %
- Table View (JavaScript)< 1 %
- Parquet Reader< 1 %
- Java Snippet< 1 %
- Double to Integer< 1 %
- End IF< 1 %
- Date&Time to legacy Date&Time< 1 %
- Variable Loop End< 1 %
- String Replacer (Dictionary)< 1 %
- List Files/Folders< 1 %
- Modify Date< 1 %
- Moving Aggregator< 1 %
- Catch Errors (Data Ports)< 1 %
- File Reader (Complex Format)< 1 %
- Column Comparator< 1 %
- Domain Calculator< 1 %
- Color Manager< 1 %
Parquet Reader< 1 %- Line Plot (JavaScript)< 1 %
- Row to Column Names< 1 %
- Copy/Move Files (legacy)< 1 %
- Variable to Table Column< 1 %
- Column Renamer (Dictionary)< 1 %
- Missing Value Column Filter< 1 %
- DB Writer< 1 %
- Heatmap (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
Extract Date&Time Fields< 1 %- Wait...< 1 %
- SAP Reader (Theobald Software)< 1 %
- Shapefile Point Reader< 1 %
- Variable to Table Row< 1 %
- Variable Condition Loop End< 1 %
- Category to Number< 1 %
- Linear Correlation< 1 %
- Rank< 1 %
- CASE Switch End< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- Similarity Search< 1 %
- String to JSON< 1 %
- Python Script (legacy)< 1 %
- Workflow Service Input< 1 %
- DB Insert< 1 %
- Collection to String< 1 %
File Reader< 1 %- Random Forest Predictor (Regression)< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Numeric Outliers< 1 %
- Extract Table Spec< 1 %
- SDF Extractor< 1 %
- Random Matcher< 1 %
- Tika Parser< 1 %
- String to Path< 1 %
- Image to DataRow< 1 %
- RDKit To Molecule< 1 %
- Date Extractor< 1 %
- Numeric Row Splitter< 1 %
- Path to String (Variable)< 1 %
- RDKit Add Hs< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Shuffle< 1 %
- PUT Request< 1 %
- Create Collection Column< 1 %
- URL to File Path< 1 %
- Counting Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Numeric Scorer< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Table Validator< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
- Reference Column Resorter< 1 %
- Table Difference Finder< 1 %
- Value Counter< 1 %
CASE Switch Data (End)< 1 %Color Appender< 1 %- SDF Reader< 1 %
- Empty Table Creator< 1 %
- Term Neighborhood Extractor< 1 %
- Term to String< 1 %
- Column Filter (legacy)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Salesforce Simple Query< 1 %
- RDKit Descriptor Calculation< 1 %
- Many to One (PMML)< 1 %
- RDKit Molecule to SVG< 1 %
- Extract Missing Value Cause< 1 %
- Microsoft Access Connector< 1 %
- Hash Calculator< 1 %
- Table to HTML String< 1 %
- Duration to Number< 1 %
Database Reader< 1 %- Row Aggregator< 1 %
- Split Collection Column< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
- CSV Writer< 1 %
- Fixed Width File Reader< 1 %
Table Reader< 1 %- Loop End (Column Append)< 1 %
- Chunk Loop Start< 1 %
- Recursive Loop End< 1 %
- k-Means< 1 %
- Decision Tree Predictor< 1 %
- K Nearest Neighbor< 1 %
- Linear Regression Learner< 1 %
- Regression Predictor< 1 %
- Scorer< 1 %
- SVM Predictor< 1 %
- Random Forest Predictor< 1 %
- Binner (Dictionary)< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Table Validator (Reference)< 1 %
- Edit Numeric Domain< 1 %
- Reference Column Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- Renderer to Image< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Molecule Type Cast< 1 %
- SDF Stripper< 1 %
- Parameterized DB Query Reader< 1 %
- Random Number Assigner< 1 %
- Variable Expressions< 1 %
- Read Excel Sheet Names< 1 %
- Java Snippet (simple)< 1 %
- PDF Parser< 1 %
- Document Data Extractor< 1 %
- Strings to Document< 1 %
- Files/Folders Meta Info< 1 %
- Path to String< 1 %
- String to Path (Variable)< 1 %
- Date&Time Configuration< 1 %
- Value Selection Configuration< 1 %
- ROC Curve (JavaScript)< 1 %
- R to Table< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- String to XML< 1 %
- RDKit From Molecule< 1 %
- Web Page Content Extractor< 1 %
Regex Extractor< 1 %- HTML Node to Text< 1 %
- Find Elements< 1 %
- Regex Substring< 1 %
- Sentence Extractor< 1 %
- Coordinate to Latitude/Longitude< 1 %
- Image to Table< 1 %
- k-Medoids< 1 %
- Variable Creator< 1 %
- DB Delete (Table)< 1 %
- Random Label Assigner< 1 %
- Catch Errors (Var Ports)< 1 %
- Numeric Binner< 1 %
- Word Parser< 1 %
- Active Branch Inverter< 1 %
- Regex Extractor< 1 %
Database Looping< 1 %- Columns to JSON< 1 %
- Rule Engine Variable< 1 %
- Column List Loop Start< 1 %
- Transfer Files (Table)< 1 %
- Math Formula (Variable)< 1 %
- Line Reader< 1 %
- String to URI< 1 %
- Table Cropper< 1 %
- Modify Time Zone< 1 %
- Try (Data Ports)< 1 %
- SharePoint Online List Reader< 1 %
- RDKit Substructure Filter< 1 %
- List Remote Files (legacy)< 1 %
- PNGs to Binary Objects< 1 %
- Breakpoint< 1 %
- Recursive Loop Start< 1 %
- Logistic Regression Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Spark to Table< 1 %
- DB Query< 1 %
- Weka Predictor (3.7)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Image Properties< 1 %
- Molecular Properties< 1 %
- Base64 Decoder< 1 %
- Number to Category (Apply)< 1 %
- Tika Language Detector< 1 %
- Stop Word Filter< 1 %
- Delete Files/Folders< 1 %
- String Configuration< 1 %
SAP Reader (Theobald Software)< 1 %- Twitter Retweet Search< 1 %
XML Reader< 1 %- Fingerprints< 1 %
- N-Gram Extractor< 1 %
- Multiport Loop End< 1 %
- Uni Reactor (By Input)< 1 %
- Extract URI Info< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %- Naive Bayes Predictor< 1 %
- Cluster Assigner< 1 %
- Entropy Scorer< 1 %
- Column Selection Configuration< 1 %
- Integer Input (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Date&Time Widget< 1 %
- Image Converter< 1 %
- Image Resizer< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
- CIR< 1 %
- XLS Control Table Generator< 1 %
- Fingerprint to Binary String< 1 %
- Load SD-Files (SDF)< 1 %
- Load Text Files< 1 %
- List To Set< 1 %
- Collection Size< 1 %
- Load text-based files< 1 %
- Random Numbers Generator< 1 %
- Trim Table< 1 %
- Z-Primes (PC x NC)< 1 %
- Fix Column Names< 1 %
- Advanced MolConverter< 1 %
- Charge< 1 %
- Dipole Moment Calculation< 1 %
- Orbital Electronegativity< 1 %
- Polarizability< 1 %
- Aqueous Solubility< 1 %
- Binary Objects to Files< 1 %
- Binary Objects to PNGs< 1 %
- Strings to Binary Objects< 1 %
- Inject Variables (Data)< 1 %
Simple File Reader< 1 %Variable Condition Loop End< 1 %- Generic Loop Start< 1 %
Recursive Loop End< 1 %- Fuzzy Rule Predictor< 1 %
- SMOTE< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- One to Many (PMML)< 1 %
- String Manipulation (Variable)< 1 %
- Cache< 1 %
- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Workflow Executor< 1 %
- DB Merge< 1 %
- DB Transaction End< 1 %
- DB Query Extractor< 1 %
- One Row to Many< 1 %
- Distance Matrix Calculate< 1 %
- H2O to Table< 1 %
- LIBSVMPredictor< 1 %
- SAS7BDAT Reader< 1 %
- Java Snippet Row Filter< 1 %
- Radar Plot Appender< 1 %
- DF< 1 %
- String Matcher< 1 %
- Flat File Document Parser< 1 %
- Transfer Files< 1 %
- Transform< 1 %
- Nominal Row Filter Configuration< 1 %
- Double Configuration< 1 %
- Integer Slider Configuration< 1 %
- CSS Editor< 1 %
- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Slider Widget< 1 %
- Refresh Button Widget< 1 %
- Table to JSON< 1 %
- Python Edit Variable (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Twitter Timeline< 1 %
- XGBoost Predictor< 1 %
- XML Row Combiner< 1 %
- Fingerprint Similarity< 1 %
- Text Classifier Predictor< 1 %
Column Distance< 1 %- String Similarity< 1 %
- Start WebDriver< 1 %
- Extract Text< 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 933 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.