This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This node concatenates tables, inputs are optional. Columns with equal names are concatenated (if the column types differ the column type is the common base type of both input column types). If one input table contains column names that the other tables do not, the columns can either be filled with missing values or filtered out, i.e. they will not be in the output table. The dialog allows setting the following parameters:
Options
Popular Predecessors
XLS Reader5 %Excel Reader (XLS)5 %Column Appender4 %- Image to Table3 %
Variable to Table Row2 %- PMML to Cell2 %
- Date&Time-based Row Filter2 %
- Column Renamer (Dictionary)2 %
Binary Scorer2 %- String to Date/Time (legacy)1 %
- Column Combiner1 %
- RDKit Substructure Filter1 %
Variable to Table Column1 %CASE Switch Data (End)1 %- Scorer (JavaScript)1 %
- Google Sheets Reader< 1 %
Cell Splitter< 1 %- Normalizer< 1 %
- Flat File Document Parser< 1 %
Recursive Loop End< 1 %- Counter Generation< 1 %
Extract Date&Time Fields< 1 %- Join Layout< 1 %
- Constant Value Column< 1 %
- Numeric Row Splitter< 1 %
Column Rename< 1 %- Empty Table Creator< 1 %
- Column Auto Type Cast< 1 %
- Nominal Value Row Splitter< 1 %
- Regression Predictor< 1 %
String To Number< 1 %- Value Counter< 1 %
- ROC Curve (JavaScript)< 1 %
- JSON to Table< 1 %
- Create Date&Time Range< 1 %
Excel Writer (XLS)< 1 %- Rank< 1 %
- HiLite Row Splitter< 1 %
- Java Snippet Row Filter< 1 %
- Numeric Binner< 1 %
- Column Filter< 1 %
- Shuffle< 1 %
- Extract Table Dimension< 1 %
- JSON Path< 1 %
- Substructure Search< 1 %
- RDKit Two Component Reaction< 1 %
- Excel Reader< 1 %
Recursive Loop Start< 1 %Numeric Scorer< 1 %- Java Snippet Row Splitter< 1 %
- Number to String< 1 %
Table Row to Variable< 1 %- Table Validator (Reference)< 1 %
- Denormalizer< 1 %
- IF Switch< 1 %
- OpenBabel< 1 %
Read Excel Sheet Names (XLS)< 1 %- Column Filter (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- RDKit One Component Reaction< 1 %
- Create Collection Column< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Database Update< 1 %- Concatenate< 1 %
- Reference Row Filter< 1 %
- Random Number Assigner< 1 %
- Extract Time Window (legacy)< 1 %
- DB Query Reader< 1 %
Excel Reader (XLS)< 1 %- Decision Tree Predictor< 1 %
Row Splitter (deprecated)< 1 %- Twitter Timeline (legacy)< 1 %
- RDKit To Molecule< 1 %
- MultiLayerPerceptron Predictor< 1 %
- TIBCO Spotfire File Reader< 1 %
- Load Layout< 1 %
- Normalize Plates (POC)< 1 %
- ARFF Reader< 1 %
- Linear Regression Learner< 1 %
Concatenate (Optional in)< 1 %- Filter Apply< 1 %
- Extract Table Spec< 1 %
- Weka Predictor (3.7)< 1 %
- RDKit Molecule Catalog Filter< 1 %
- Row Splitter (col+)< 1 %
- Loop End (Column Append)< 1 %
- Category to Number< 1 %
- Equal Size Sampling< 1 %
- Missing Value (Apply)< 1 %
- Table Transposer< 1 %
Excel Reader (XLS)< 1 %- NGram Creator< 1 %
- PDF Parser< 1 %
- Strings to Document< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
Counting Loop Start< 1 %- Numeric Outliers< 1 %
- HTML Parser< 1 %
- Joiner< 1 %
- Canonical SMILES< 1 %
- Outlier Removal< 1 %
Database Looping< 1 %Table Writer< 1 %Loop End (2 ports)< 1 %Loop End< 1 %Variable Condition Loop End< 1 %Recursive Loop Start (2 ports)< 1 %Naive Bayes Predictor< 1 %K Nearest Neighbor< 1 %Random Forest Predictor< 1 %- Reference Column Splitter< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Sorter< 1 %
- String Replacer< 1 %
- Rule-based Row Filter< 1 %
- Line Plot (JavaScript)< 1 %
- CIR< 1 %
- Fragments to MMPs< 1 %
- Random Forest Predictor< 1 %
- Amazon Translate< 1 %
- DB Insert< 1 %
- DB Update< 1 %
- Table to HTML String< 1 %
- RDKit Fingerprint< 1 %
- Fingerprint Similarity< 1 %
- List Remote Files (legacy)< 1 %
CSV Writer< 1 %- Tree Ensemble Model Extract< 1 %
- Bootstrap Sampling< 1 %
- Column Name Extractor< 1 %
Linear Correlation< 1 %Row Filter (deprecated)< 1 %- Normalizer (Apply)< 1 %
- String Manipulation< 1 %
- Rule Engine< 1 %
- Java Snippet (simple)< 1 %
- String to Date&Time< 1 %
XML Reader< 1 %- XPath< 1 %
- Fingerprints< 1 %
RDKit Functional Group Filter< 1 %- Numeric Scorer< 1 %
- Table Validator< 1 %
- Duplicate Row Filter< 1 %
Number To String (PMML)< 1 %- RDKit Molecule Substructure Filter< 1 %
- RDKit Substructure Counter< 1 %
Loop End (Upto 4 ports)< 1 %- Split Collection Column< 1 %
Parameterized Database Query< 1 %File Reader< 1 %- Table Creator< 1 %
- Java Edit Variable< 1 %
- Logistic Regression Learner< 1 %
- SVM Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %- Add Empty Rows< 1 %
- Column Merger< 1 %
- Column Resorter< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- GroupBy< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rule-based Row Splitter< 1 %
- End IF< 1 %
- Generic Web Service Client< 1 %
- Math Formula< 1 %
- String Matcher< 1 %
- Tag Filter< 1 %
- Parameter Optimization Loop End< 1 %
- R to Table< 1 %
- Date&Time Difference< 1 %
- Date&Time Shift< 1 %
- HTTP Retriever< 1 %
- Apply Transforms (RDKit) (Experimental)< 1 %
- String to Number< 1 %
- One to Many< 1 %
- Network to Row< 1 %
- CSV Reader< 1 %
- Loop End< 1 %
- Fingerprint Similarity< 1 %
- Shapefile Polygon Reader< 1 %
- String to URI< 1 %
- Wait...< 1 %
Table Row To Variable Loop Start< 1 %- X-Aggregator< 1 %
Regression Predictor< 1 %- Cell Splitter By Position< 1 %
- Subset Matcher< 1 %
- String Splitter (Regex)< 1 %
CASE Switch Data (Start)< 1 %- SDF Extractor< 1 %
- SDF Stripper< 1 %
- Math Formula (Multi Column)< 1 %
- String to Term< 1 %
- Value Filter (legacy)< 1 %
- JSON Row Combiner< 1 %
- Moving Aggregator< 1 %
- XML Column Combiner< 1 %
- String to XML< 1 %
Table to HTML String< 1 %- RDKit To InChI< 1 %
- String Similarity< 1 %
- Hydrogen Remover< 1 %
- Binner (Dictionary)< 1 %
- Constant Value Column Filter< 1 %
String To Number (PMML)< 1 %- Similarity Search< 1 %
- Local Thresholding< 1 %
- RDKit Chemical Transformation< 1 %
- Substructure Matcher< 1 %
- Standardizer< 1 %
- Active Branch Inverter< 1 %
List Files< 1 %- Java Snippet< 1 %
- k-Means< 1 %
PCA< 1 %- Auto-Binner< 1 %
- Double to Integer< 1 %
- Low Variance Filter< 1 %
- Reference Column Resorter< 1 %
- One-way ANOVA< 1 %
- Cache< 1 %
Color Appender< 1 %- Geo-Coordinate Row Filter< 1 %
- IDF< 1 %
- TF< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to JSON< 1 %
- Columns to JSON< 1 %
- Image Resizer< 1 %
- POST Request< 1 %
- UNIX Timestamp to Date&Time< 1 %
- RDKit From Molecule< 1 %
MapzenGeocoder< 1 %- Expand Barcode< 1 %
- Plate Heatmap Viewer< 1 %
- Try (Data Ports)< 1 %
- Chunk Loop Start< 1 %
- Lag Column< 1 %
- Set Operator< 1 %
Rank Correlation< 1 %- Timer Info< 1 %
- Crosstab< 1 %
- Document Data Extractor< 1 %
- GET Request< 1 %
- RDKit Descriptor Calculation< 1 %
- Number to String (PMML)< 1 %
- InChi< 1 %
- Simulate Market< 1 %
- R Snippet (2:1)< 1 %
- Advanced MolConverter< 1 %
- MolImporter< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %- Feature Selection Loop End< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %Variable Loop End< 1 %- PNN Predictor< 1 %
Tree Ensemble Learner< 1 %Tree Ensemble Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Column Comparator< 1 %
Number To String< 1 %- Reference Column Filter< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- Data Generator< 1 %
- Color Manager< 1 %
- Save Workflow< 1 %
- Molecule Type Cast< 1 %
- Parallel Chunk End< 1 %
- DB Reader< 1 %
- Random Label Assigner< 1 %
- Random Matcher< 1 %
- Stresser< 1 %
- Column Expressions (legacy)< 1 %
- Document Grabber< 1 %
- Term to String< 1 %
- Table View (JavaScript)< 1 %
- JSON to XML< 1 %
Python Script (1⇒2)< 1 %- R Source (Table)< 1 %
- Date&Time to String< 1 %
- Time Generator (legacy)< 1 %
Twitter Streaming (legacy)< 1 %- Molecular Properties< 1 %
- RDKit Molecule Highlighting< 1 %
- Google Address Geocoder< 1 %
- Standardizer< 1 %
- Random Numbers Generator< 1 %
- JC4XL Reader< 1 %
Element Selector< 1 %- ARIMA Parameter Extractor< 1 %
- URI to String< 1 %
SQL Extract< 1 %- X-Partitioner< 1 %
- Fuzzy Rule Predictor< 1 %
- PNN Learner (DDA)< 1 %
- K Nearest Neighbor< 1 %
- Tree Ensemble Predictor< 1 %
- Column to Grid< 1 %
- Create Table Structure< 1 %
- String to Number (PMML)< 1 %
- Renderer to Image< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- HiLite Table (legacy)< 1 %
- Extract Color< 1 %
- Visualization Property Extractor< 1 %
Parquet Reader< 1 %- k-Medoids< 1 %
Strings To Document< 1 %- External Tool (Labs)< 1 %
- String Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
Python Script (1⇒2)< 1 %- Legacy Date&Time to Date&Time< 1 %
- Modify Date< 1 %
- RDKit Add Hs< 1 %
Extract Attribute< 1 %Extract Outer/InnerHTML< 1 %- Reaxys Substances< 1 %
- R-Group Decomposer< 1 %
Loop End (3 ports)< 1 %- List Folders< 1 %
- Number Formatter< 1 %
- Operetta Reader< 1 %
- Bi Reactor< 1 %
- Geometrical Descriptors< 1 %
- MolSearch< 1 %
- Multiple MolImporter< 1 %
- MarvinSketch< 1 %
- MolConverter< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
- Read Images< 1 %
- Fixed Width File Reader< 1 %
Line Reader< 1 %Table Reader< 1 %- Hierarchical Cluster Assigner (local)< 1 %
- Polynomial Regression Learner< 1 %
Scorer< 1 %- SMOTE< 1 %
- SOTA Predictor< 1 %
- Tree Ensemble Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Expand Bit Vector< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Column Aggregator< 1 %
- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
Double To Int< 1 %- Partitioning< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- Paired t-test< 1 %
- Independent groups t-test< 1 %
- Statistics< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
Merge Variables< 1 %- Conditional Box Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Molfile Reader< 1 %
- Mol2 Reader< 1 %
- SDF Reader< 1 %
- One Row to Many< 1 %
- Model to Cell< 1 %
- H2O to Table< 1 %
Bag of Words Creator< 1 %Google Analytics Query (deprecated)< 1 %- JSON Column Combiner< 1 %
- Container Input (Table)< 1 %
- Table to JSON< 1 %
JSON Reader< 1 %- Gaussian Convolution< 1 %
- Don't Save End< 1 %
- Network Analyzer< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- R Snippet< 1 %
- R View (Table)< 1 %
- SPARQL Query< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Twitter Search (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Diversity Picker< 1 %
- Aromatizer< 1 %
- Dearomatizer< 1 %
- Molecule Transformation (beta)< 1 %
- Valence Checker< 1 %
- Speedy SMILES Ring Count< 1 %
IF Switch (Flow Variable Value)< 1 %IF Switch (Flow Variable Value)< 1 %Loop End (Upto 6 ports)< 1 %- Load SD-Files (SDF)< 1 %
- Run Garbage Collector< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Benchmark Start (2 ports)< 1 %
- FASTA Sequence Extractor< 1 %
- Combine Columns by Header< 1 %
- Binning Apply< 1 %
- Normalize Plates (NPI)< 1 %
- Spell Checker (simple)< 1 %
- Elemental Analysis< 1 %
- HLB< 1 %
- logP< 1 %
- Major Microspecies< 1 %
- pKa< 1 %
- Table to String< 1 %
- Acoustic Feature Extractor< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- PNGs to Binary Objects< 1 %
- Unzip Files (legacy)< 1 %
- Feature Selection Filter< 1 %
Interval Loop Start< 1 %Naive Bayes Learner< 1 %- Naive Bayes Learner< 1 %
- Hierarchical Clustering< 1 %
- DBSCAN< 1 %
- Logistic Regression Predictor< 1 %
- Entropy Scorer< 1 %
- Association Rule Learner< 1 %
- PCA< 1 %
Gradient Boosted Trees Predictor< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
Random Forest Learner< 1 %- Cell Splitter< 1 %
- Many to One< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- One to Many (PMML)< 1 %
- Target Shuffling< 1 %
- Decision Tree to Ruleset< 1 %
- Rule Engine (Dictionary)< 1 %
- Kolmogorov-Smirnov Test< 1 %
- Box Plot (legacy)< 1 %
- Shape Manager< 1 %
- Spark Scorer< 1 %
- Smiles Directory Reader< 1 %
- Fingerprint Bayesian Predictor< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Parallel Chunk End (multi port)< 1 %
- Parameterized DB Query Reader< 1 %
- Conditional Label Assigner< 1 %
- Random Number Assigner (Apache)< 1 %
- TimeDelay Loop End< 1 %
- PMML Ensemble Predictor< 1 %
- PMML Predictor< 1 %
- External Tool< 1 %
H2O MOJO Predictor (Classification)< 1 %H2O Multinomial Scorer< 1 %- SAS7BDAT Reader< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Keygraph Keyword Extractor< 1 %
- Stop Word Filter< 1 %
- Tika Parser< 1 %
Dictionary tagger< 1 %- Bag Of Words Creator< 1 %
- Tags to String< 1 %
- Nominal Row Filter Configuration< 1 %
- File Chooser (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Average Filter< 1 %
- Anisotropic Diffusion< 1 %
- Seed Generator< 1 %
- Dimension Swapper< 1 %
- Inverter< 1 %
- Image to Labeling< 1 %
- Gaussian Blur...< 1 %
- Tess4J< 1 %
Python Script (2⇒1)< 1 %Value Selection QuickForm (legacy)< 1 %- Test Data Generator< 1 %
- Fail in execution< 1 %
- Duration to String< 1 %
- Duration to Number< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Time< 1 %
- Modify Time Zone< 1 %
- Preset Date/Time (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
- XML Row Combiner< 1 %
- RDKit Interactive Table< 1 %
- RDKit From IUPAC< 1 %
- RDKit Salt Stripper< 1 %
- MapQuest Geocoder< 1 %
RMSE Calculator< 1 %- HTML Node to Text< 1 %
- Find Elements< 1 %
- Synchronize< 1 %
- Fingerprint to String< 1 %
- File Reader< 1 %
- Table Reader< 1 %
- Naive Bayes Predictor< 1 %
- Scorer< 1 %
- Random Forest Learner (Regression)< 1 %
- String Manipulation (Multi Column)< 1 %
Parquet Reader< 1 %- File Chooser Widget< 1 %
- Structure Sketcher< 1 %
Views
- This node has no views
Workflows
Credit Scoring Model(diksha kumari)KNIME Hub- _01_Network_Traffic_ReportingKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 00_Scalable_Data_GenerationKNIME Hub
- 00_Scalable_Data_GenerationKNIME Hub
- Show all 171 workflows
Links
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.