This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementMerge VariablesMerges flow variables into one stream. This node aggregates variables defined in different input connections into one variable connection. It does not modify variables but only merges them. Note, if there are the same variables defined in different inputs, the standard conflict handling is applied: Top most inputs take priority and define the value of a variable. This node can also be used as a common barrier point to control the execution order of nodes, i.e. nodes connected to the output port will not start executing until all upstream nodes have been executed.
Popular Successors
- Math Formula (Variable)7 %
Variable to Table Column4 %- Java Snippet4 %
- Math Formula3 %
- Java Edit Variable (simple)3 %
Column Rename3 %- Inject Variables (Data)2 %
- R Snippet2 %
CSV Reader2 %- Constant Value Column2 %
- R View (Table)2 %
Joiner1 %File Reader1 %- GET Request1 %
- Generic JavaScript View (JavaScript)1 %
- Create Directory (legacy)< 1 %
Variable to Table Column< 1 %CASE Switch Variable (End)< 1 %- Column Expressions< 1 %
CASE Switch Data (Start)< 1 %- Catch Errors (Var Ports)< 1 %
Table Row To Variable Loop Start< 1 %- IF Switch< 1 %
Variable Condition Loop End< 1 %- R Source (Table)< 1 %
- Create Temp Dir (legacy)< 1 %
- Text Output (legacy)< 1 %
Table Reader< 1 %- Table to R< 1 %
- Google Analytics Query (legacy)< 1 %
- Empty Table Creator< 1 %
- String Input (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
Table Row to Variable< 1 %Database Table Connector< 1 %Column Filter Configuration< 1 %- Group Loop Start< 1 %
- DBSCAN< 1 %
- DB Row Filter< 1 %
- Text Output Widget (legacy)< 1 %
- Save Workflow< 1 %
- Hive Connector< 1 %
- Decision Tree Learner< 1 %
- Concatenate< 1 %
- DB Query Reader< 1 %
Cell Replacer< 1 %- Java Snippet (simple)< 1 %
Container Input (Variable)< 1 %Python Edit Variable< 1 %- Try (Variable Ports)< 1 %
Interval Loop Start< 1 %Recursive Loop Start< 1 %- Column Rename (Regex)< 1 %
- End IF< 1 %
- Parameter Optimization Loop Start< 1 %
- Python Learner (legacy)< 1 %
- R View (Workspace)< 1 %
Variable to Table Row< 1 %Database Reader< 1 %- Column List Loop Start< 1 %
- Random Forest Learner< 1 %
- Column Merger< 1 %
Row Splitter (deprecated)< 1 %Merge Variables< 1 %- Send Email< 1 %
- Document Grabber< 1 %
- Create Date&Time Range< 1 %
Database SQL Executor< 1 %Line Reader< 1 %- RProp MLP Learner< 1 %
- String Manipulation (Variable)< 1 %
- Microsoft SQL Server Connector< 1 %
- External Tool< 1 %
- Math Formula (Multi Column)< 1 %
- File Download (legacy)< 1 %
- Upload (legacy)< 1 %
- URL to File Path (Variable)< 1 %
- Active Branch Inverter< 1 %
- Chunk Loop Start< 1 %
- Auto-Binner< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
Hive Connector< 1 %- Single Selection (legacy)< 1 %
- Python View (legacy)< 1 %
- R Source (Workspace)< 1 %
Flow Variable End IF< 1 %- Spark DataFrame Java Snippet (Source)< 1 %
- DB SQL Executor< 1 %
- Line Plot (Plotly)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %- Slider Input (legacy)< 1 %
- Twitter Search< 1 %
- Knime To SDF Port< 1 %
Flow Variable IF Switch< 1 %Extract Context Properties< 1 %Table Writer< 1 %- SDF Writer< 1 %
- DB Table Remover< 1 %
- Value Selection (legacy)< 1 %
- R to R< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Zip Files (legacy)< 1 %
Database Drop Table< 1 %PMML Writer< 1 %Generic Loop Start< 1 %Variable Loop End< 1 %Tree Ensemble Learner< 1 %- Column Name Extractor< 1 %
- Lag Column< 1 %
- Reference Row Filter< 1 %
- Pivot< 1 %
- SDF Reader< 1 %
- Similarity Search< 1 %
- Shortest Path< 1 %
Python Script (2⇒2)< 1 %Input File< 1 %IF Switch (Flow Variable Value)< 1 %- Range Filter< 1 %
- SSH Connection (legacy)< 1 %
- Table Creator< 1 %
- Feature Selection Loop End< 1 %
Random Forest Learner< 1 %- Binner (Dictionary)< 1 %
- Column Aggregator< 1 %
- Column Resorter< 1 %
- Column Filter< 1 %
Row Filter (deprecated)< 1 %- Table Transposer< 1 %
- Rule Engine< 1 %
CASE Switch Data (End)< 1 %- Destroy Spark Context< 1 %
- Parallel Chunk Start< 1 %
- DB Connection Closer< 1 %
- DB Table Selector< 1 %
- Java IF (Table)< 1 %
- Column Selection Widget< 1 %
- JSON Path< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒2)< 1 %- File Difference Checker< 1 %
- String to Date&Time< 1 %
- Write Variables< 1 %
Binary Objects to Files< 1 %- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
List Files< 1 %PMML Reader< 1 %Loop End (2 ports)< 1 %- Linear Regression Learner< 1 %
Numeric Scorer< 1 %- Association Rule Learner< 1 %
Gradient Boosted Trees Learner< 1 %- Cell Splitter By Position< 1 %
- Column Renamer (Dictionary)< 1 %
- RowID< 1 %
- Rule Engine Variable< 1 %
PostgreSQL Connector< 1 %- PostgreSQL Connector< 1 %
- DB Query< 1 %
- TimeDelay Loop Start< 1 %
- Bar Chart (JavaScript)< 1 %
- Variable Expressions< 1 %
- Line Chart (JFreeChart)< 1 %
Google Authenticator (API Key)< 1 %- Credentials Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Single Selection Widget< 1 %
- Image Cropper< 1 %
- Python Source (legacy)< 1 %
- R Learner< 1 %
- Extract Time Window (legacy)< 1 %
- Table to HTML String< 1 %
XLS Formatter (apply)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Create Collection Column< 1 %
- Delete Files (legacy)< 1 %
- URL to File Path< 1 %
- Catch Errors (Data Ports)< 1 %
Scorer< 1 %- Numeric Row Splitter< 1 %
Amazon Redshift Connector< 1 %Microsoft SQL Server Connector< 1 %- DB Reader< 1 %
- DB Writer< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Explorer Browser< 1 %
Table to PDF< 1 %- OSM Map to Image< 1 %
XLS Reader< 1 %- External SSH Tool< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Single Selection Configuration< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Multiple Selection Widget< 1 %
Python Script (1⇒1)< 1 %- Python Predictor (legacy)< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Window Slider< 1 %
Input Directory< 1 %- Output File< 1 %
- Random Numbers Generator< 1 %
- Outlier Removal< 1 %
- List Files with Authentication< 1 %
- Create File Name (legacy)< 1 %
Variable to Table Row< 1 %- Image to Table< 1 %
Database Delete< 1 %Database Query< 1 %Database Row Filter< 1 %Database Looping< 1 %- Java Edit Variable< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Counting Loop Start< 1 %Recursive Loop End< 1 %- SVM Learner< 1 %
- SVM Predictor< 1 %
Random Forest Learner< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Learner (Regression)< 1 %
- Column Combiner< 1 %
- Create Table Structure< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- String Manipulation< 1 %
- Independent groups t-test< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- MySQL Connector< 1 %
- DB Query Injector< 1 %
- Keras Network Reader< 1 %
- DL Python Network Creator< 1 %
- H2O Random Forest Learner (Regression)< 1 %
- Histogram Chart (JFreeChart)< 1 %
Read XLS Sheet Names< 1 %XLS Writer< 1 %Excel Reader (XLS)< 1 %- Java Snippet Row Filter< 1 %
- PDF Parser< 1 %
- Tika Parser< 1 %
- t-SNE (L. Jonsson)< 1 %
Google Sheets Interactive Service Provider< 1 %- Google Sheets Updater< 1 %
- Google Sheets Writer< 1 %
- Date&Time Configuration< 1 %
- Integer Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Column Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Container Output (JSON)< 1 %
- Python Edit Variable (legacy)< 1 %
- Add Table to R< 1 %
- Date&Time Difference< 1 %
- Date/Time Shift (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Twitter Timeline< 1 %
XML Reader< 1 %- RDKit Interactive Table< 1 %
- HTTP Retriever< 1 %
- Navigate< 1 %
- Quit WebDriver< 1 %
- Fast Fourier Transform (FFT)< 1 %
- WAV Reader< 1 %
- XLS Sheet Selector< 1 %
- XLS Control Table from Cell Range< 1 %
- KNIME Server Connection (legacy)< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
IF Switch (Flow Variable Value)< 1 %Database IF Switch (Flow Variable Value)< 1 %- Variable Timed Loop End< 1 %
- Load SD-Files (SDF)< 1 %
- Benchmark Start< 1 %
- URL Encode< 1 %
PDB Connector Query Only (XML Query)< 1 %- Range Splitter< 1 %
- Matlab Snippet< 1 %
Variable Based MolImporter< 1 %- XLS Coloured Writer< 1 %
- ARIMA Learner< 1 %
- List Audio Files< 1 %
- Download (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Extract Variables (Database)< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Database)< 1 %
Variable to Table Row< 1 %Image Writer (Port)< 1 %CSV Writer< 1 %Database Connection Table Reader< 1 %Database Writer< 1 %SQL Inject< 1 %Database Table Selector< 1 %Database Connector< 1 %Parameterized Database Query< 1 %- Fixed Width File Reader< 1 %
Loop End< 1 %Recursive Loop End (2 ports)< 1 %- Fuzzy Rule Learner< 1 %
- Decision Tree to Image< 1 %
K Nearest Neighbor< 1 %- Polynomial Regression Learner< 1 %
Regression Predictor< 1 %- Regression Predictor< 1 %
- Numeric Scorer< 1 %
- Random Forest Learner (Regression)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Add Empty Rows< 1 %
Concatenate (Optional in)< 1 %- Numeric Binner< 1 %
- Bootstrap Sampling< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
Number To String< 1 %- Number to String< 1 %
Column Appender< 1 %- Correlation Filter< 1 %
- Table Validator (Reference)< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- GroupBy< 1 %
- Normalizer< 1 %
- Missing Value< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
- Renderer to Image< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Ruleset Editor< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Single sample t-test< 1 %
CASE Switch Model (Start)< 1 %CASE Switch Variable (Start)< 1 %- Empty Table Switch< 1 %
- Data Generator< 1 %
- Timer Info< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
ORC Writer< 1 %Parquet Writer< 1 %Impala Loader (legacy)< 1 %- Spark Column Rename (Regex)< 1 %
- Spark SQL Query< 1 %
- Molecule Type Cast< 1 %
- Mol2 Reader< 1 %
Amazon Athena Connector< 1 %- Amazon Personalize Create Solution Version< 1 %
- Amazon Redshift Connector< 1 %
- Amazon S3 Connection (legacy)< 1 %
- Amazon S3 File Picker (legacy)< 1 %
- Azure Blob Store Connection (legacy)< 1 %
- Parallel Chunk End< 1 %
MySQL Connector< 1 %SQLite Connector< 1 %- H2 Connector< 1 %
- Oracle Connector< 1 %
- DB Connector< 1 %
- DB Delete (Table)< 1 %
- DB Insert< 1 %
- DB Merge< 1 %
- DB Pivot< 1 %
- DB Transaction End< 1 %
- DB Transaction Start< 1 %
- One Row to Many< 1 %
- Keras Input Layer< 1 %
- Keras LSTM Layer< 1 %
- DL Python Network Executor< 1 %
- DL Python Network Learner< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Prediction Fusion< 1 %
- OpenBabel< 1 %
H2O Random Forest Learner< 1 %- H2O Isolation Forest Learner< 1 %
- Index Query< 1 %
XLS Sheet Appender< 1 %Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Send to Tableau Server (Hyper)< 1 %- PubMed Document Parser< 1 %
- Dictionary Tagger< 1 %
- External Tool (Labs)< 1 %
- Google Sheets Reader< 1 %
- Nominal Row Filter Configuration< 1 %
- Boolean Configuration< 1 %
- String Configuration< 1 %
- Value Selection Configuration< 1 %
- Credentials Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Credentials Widget< 1 %
- Date&Time Widget< 1 %
- String Widget< 1 %
- Image Output Widget (legacy)< 1 %
- Table to JSON< 1 %
- JSON Transformer< 1 %
JSON Reader< 1 %- JSON to Table< 1 %
- Labeling Filter< 1 %
MongoDB Reader< 1 %MongoDB Writer< 1 %Python Learner< 1 %Python Script (2⇒1)< 1 %Python Source< 1 %Python View< 1 %Python Script (2⇒1)< 1 %- DELETE Request< 1 %
- POST Request< 1 %
- Git Fetch< 1 %
- SPARQL Query< 1 %
- Twitter API Connector< 1 %
Twitter Streaming< 1 %XGBoost Tree Ensemble Learner< 1 %- XPath< 1 %
- Fingerprints< 1 %
- Substructure Search< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Molecule Highlighting< 1 %
- RDKit From Molecule< 1 %
- RDKit Substructure Filter< 1 %
- Geo Distances< 1 %
WebDriver Factory< 1 %- WebDriver Factory< 1 %
Send Keys< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 01 Taxi Demand Prediction on Spark TrainingKNIME Hub
- 01 Time Series VisualizationKNIME Hub
- Show all 927 workflows
Links
- KNIME E-Learning Course: Creation and usage of Flow Variables in a KNIME workflowwww.knime.com/knime-introductory-course/chapter7/section1/creation-and-usage-of-flow-variables
- A question in knimeby qqilihq on 2019-04-07forum.knime.com/p/58192
- Selecting/filtering rows of a database by different flow variablesby izaychik63 on 2020-04-16forum.knime.com/p/87805
- Orchestration of nodes that don’t provide outputby qqilihq on 2018-08-03forum.knime.com/p/46151
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.