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 Predecessors
- SDF Writer11 %
- Excel Writer4 %
Date Input (legacy)3 %- Rule Engine3 %
- End IF2 %
- Text Output (legacy)2 %
XLS Writer1 %- Column Filter (legacy)1 %
String Input (legacy)1 %- Table Creator1 %
- Extract Table Dimension1 %
CSV Writer< 1 %- Column List Loop Start< 1 %
Integer Input (legacy)< 1 %Flow Variable IF Switch< 1 %CSV Reader< 1 %- Parameter Optimization Loop Start< 1 %
- CSV Writer< 1 %
File Reader< 1 %- Generic JavaScript View (JavaScript)< 1 %
Excel Sheet Appender (XLS)< 1 %- Delete Files (legacy)< 1 %
- Group Loop Start< 1 %
- Interactive Histogram (legacy)< 1 %
- Google Sheets Updater< 1 %
Python Script (1⇒1)< 1 %Table Column to Variable< 1 %- DB Query Extractor< 1 %
- Google Sheets Reader< 1 %
Column Selection Configuration< 1 %- Read Variables< 1 %
Table Writer< 1 %- Concatenate< 1 %
- Single Selection (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
Merge Variables< 1 %- File Chooser (legacy)< 1 %
- List Box Input (legacy)< 1 %
Python Edit Variable< 1 %- Column Selection Configuration< 1 %
- Catch Errors (Data Ports)< 1 %
List Files< 1 %Double Input (legacy)< 1 %Single Selection Input QuickForm (legacy)< 1 %- Table Difference Checker< 1 %
SQL Extract< 1 %- MolExporter< 1 %
Table Row to Variable< 1 %- Molecule String Input (legacy)< 1 %
Boolean Input (legacy)< 1 %File Upload (legacy)< 1 %Column Rename< 1 %- Empty Table Switch< 1 %
- DB Connector< 1 %
- String Widget< 1 %
- GET Request< 1 %
- Active Branch Inverter< 1 %
- R Snippet< 1 %
- DB Table Remover< 1 %
- Credentials Configuration< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %Database Query< 1 %- SDF Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %Value Selection QuickForm (legacy)< 1 %- URL to File Path< 1 %
- DB Reader< 1 %
- Autocomplete Text Widget< 1 %
- Explorer Browser< 1 %
- Boolean Configuration< 1 %
Generic Loop Start< 1 %- Rule-based Row Filter< 1 %
- Statistics< 1 %
- Empty Table Creator< 1 %
XLS Sheet Appender< 1 %- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
XML Writer< 1 %- Reference Row Filter< 1 %
- Variable Expressions< 1 %
Excel Writer (XLS)< 1 %- Line Plot (JavaScript)< 1 %
- Credentials Widget< 1 %
- Table Column to Variable< 1 %
- Create Temp Folder< 1 %
- TIBCO Spotfire File Writer< 1 %
- URL to File Path (Variable)< 1 %
- Catch Errors (Generic Ports)< 1 %
- Inject Variables (Data)< 1 %
Table Row To Variable Loop Start< 1 %Counting Loop Start< 1 %Concatenate (Optional in)< 1 %- String Manipulation (Variable)< 1 %
- Rule Engine Variable< 1 %
- Create Temp Dir (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Credentials Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
Column Selection QuickForm (legacy)< 1 %- R View (Table)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- HTTP Connection (legacy)< 1 %
Table Row to Variable< 1 %- Merge Variables< 1 %
- DB Connection Closer< 1 %
- DB Insert< 1 %
- DB Update< 1 %
- DB Writer< 1 %
Send to Power BI< 1 %- Shapefile writer< 1 %
- Date&Time Configuration< 1 %
- Integer Configuration< 1 %
- List Box Configuration< 1 %
- String Configuration< 1 %
- Single Selection Configuration< 1 %
- CSS Editor< 1 %
- Date&Time Widget< 1 %
- Integer Widget< 1 %
- Value Selection Widget< 1 %
- Table Row to Variable< 1 %
- CASE Switch End< 1 %
- Google Sheets Writer< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- URI Port to Variable< 1 %
- Zip Files (legacy)< 1 %
Database Connection Table Reader< 1 %Database Delete< 1 %Cell Splitter< 1 %- RowID< 1 %
- Sorter< 1 %
Table to HTML< 1 %- Math Formula (Variable)< 1 %
- Table View (JavaScript)< 1 %
Database Table Connector< 1 %Recursive Loop Start< 1 %- DB Delete (Table)< 1 %
- DB SQL Executor< 1 %
- Math Formula< 1 %
Send to Tableau Server (Hyper)< 1 %- Double Widget< 1 %
- Column Selection Widget< 1 %
- Container Input (Credentials)< 1 %
Python Script (2⇒1)< 1 %- Date&Time to String< 1 %
- Table to HTML String< 1 %
- Variable Creator< 1 %
- Table Row to Variable Loop Start< 1 %
- Chunk Loop Start< 1 %
String To Number< 1 %Row Splitter (deprecated)< 1 %- GroupBy< 1 %
- Java Edit Variable (simple)< 1 %
- Document Viewer< 1 %
- Tag Cloud< 1 %
String Radio Buttons (legacy)< 1 %- Table to R< 1 %
- Download / Upload from List (legacy)< 1 %
- Try (Variable Ports)< 1 %
- DBSCAN< 1 %
- Add Empty Rows< 1 %
- Line Plot (legacy)< 1 %
- Color Manager< 1 %
DB Loader< 1 %- Parameterized DB Query Reader< 1 %
- DB Row Filter< 1 %
DB Table Creator< 1 %Column Filter Configuration< 1 %- File Chooser Widget< 1 %
- Unpersist Spark DataFrame/RDD< 1 %
- Excel Reader< 1 %
- String to Date&Time< 1 %
- Copy/Move Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
Table Column to Variable< 1 %Database Connection Table Writer< 1 %Database Writer< 1 %Loop End< 1 %Variable Loop End< 1 %- Column Resorter< 1 %
Joiner< 1 %- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (End)< 1 %Table to PDF< 1 %- Java Snippet (simple)< 1 %
- File Download (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- Double Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
Container Input (Variable)< 1 %Python Source< 1 %- R Source (Table)< 1 %
- R Source (Workspace)< 1 %
- String to Date/Time (legacy)< 1 %
XLS Formatter (apply)< 1 %- Upload (legacy)< 1 %
Variable to Table Row< 1 %Database Looping< 1 %PMML Writer< 1 %Interval Loop Start< 1 %- Random Forest Predictor (Regression)< 1 %
- DB Merge< 1 %
- DB Query Reader< 1 %
- DB Transaction End< 1 %
Excel Reader (XLS)< 1 %- SharePoint Online Connector< 1 %
- Local File Browser Configuration< 1 %
- File Upload Widget< 1 %
- Extract Context Properties< 1 %
Input File< 1 %Flow Variable End IF< 1 %- R Plot< 1 %
- DecoyDatabase< 1 %
Binary Objects to Files< 1 %- Create Directory (legacy)< 1 %
- Wait...< 1 %
- Create File Name (legacy)< 1 %
- Extract Variables (Data)< 1 %
Image Writer (Port)< 1 %Database Reader< 1 %Database SQL Executor< 1 %Database Update< 1 %Extract Context Properties< 1 %Table Reader< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
- Feature Selection Filter< 1 %
- X-Partitioner< 1 %
- k-Means< 1 %
Scorer< 1 %Random Forest Learner< 1 %Cell Replacer< 1 %Number To String< 1 %- Column Filter< 1 %
- Reference Column Filter< 1 %
Row Filter (deprecated)< 1 %- String Manipulation< 1 %
- Ungroup< 1 %
CASE Switch Variable (Start)< 1 %- IF Switch< 1 %
- Cache< 1 %
- Send Email< 1 %
- Scatter Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Parallel Chunk End< 1 %
XLS Reader< 1 %Excel Writer (XLS)< 1 %- Java Snippet Row Filter< 1 %
- File Upload (legacy)< 1 %
- Slider Input (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
Network Writer< 1 %Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
Value Filter QuickForm (legacy)< 1 %- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- XPath< 1 %
Table to HTML String< 1 %Extract Outer/InnerHTML< 1 %- Wait< 1 %
- WAV Reader< 1 %
IF Switch (Flow Variable Value)< 1 %- Table Row To Variable Run-to-time Loop Start< 1 %
- Variable Timed Loop End< 1 %
- Load Text Files< 1 %
- Benchmark End (3 ports)< 1 %
- Benchmark Start (Memory Monitoring)< 1 %
Python Plot< 1 %- Extract Variables (Database)< 1 %
Table Column to Variable< 1 %Line Reader< 1 %Model Writer< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %- Numeric Scorer< 1 %
- Random Forest Learner< 1 %
- Auto-Binner< 1 %
- Column Auto Type Cast< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Table Validator (Reference)< 1 %
- Domain Calculator< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- Save Workflow< 1 %
ORC Writer< 1 %Parquet Writer< 1 %- Spark SQL Query< 1 %
- Parallel Chunk End (multi port)< 1 %
- Microsoft SQL Server Connector< 1 %
- Counter Generation< 1 %
- Random Number Assigner< 1 %
- Random Number Assigner (Apache)< 1 %
- Keras Network Reader< 1 %
- Column Expressions< 1 %
- Line Chart (JFreeChart)< 1 %
Google Drive Connection< 1 %- Column Filter Configuration< 1 %
- Double Configuration< 1 %
- Repository File Chooser Configuration< 1 %
- Integer Slider Configuration< 1 %
- Value Selection Configuration< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Boolean Widget< 1 %
- Slider Widget< 1 %
- Multiple Selection Widget< 1 %
- Single Selection Widget< 1 %
- JSON Row Combiner and Writer< 1 %
- Table to JSON< 1 %
- Python Object Writer (legacy)< 1 %
Date (String) Input (legacy)< 1 %File Download (legacy)< 1 %- Image to Report (BIRT)< 1 %
- POST Request< 1 %
- Credentials Validate Test< 1 %
- Database Connection Closer< 1 %
- Fail in execution< 1 %
- Create Date&Time Range< 1 %
- Date&Time-based Row Filter< 1 %
- RDKit From Molecule< 1 %
- HTTP Retriever< 1 %
- Download (legacy)< 1 %
- Table Writer< 1 %
- Generic Loop Start< 1 %
- Multiple Selection Configuration< 1 %
- Column Filter Widget< 1 %
- Text Output Widget (legacy)< 1 %
JSON Writer< 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.