This node allows the creation of flow variables of different types and custom values.
Notes:
- The variables defined by this node take precedence over upstream ones (on the Variable Inport). Thus upstream variables will get overridden by defined variables with the same name and type. The node will notify you in the case this happens.
- It is possible to define variables with the same names but different types as already defined upstream variables. However, keep in mind that this will probably lead to unexpected behavior downstream and should thus be avoided.
- The node will automatically add a variable called “variable_1” when it is initially created, even before you configure it.
The possible data types for the created variables are:
- String: A string of characters. This is the default when a new variable is created. The default value is an empty string.
- Integer: An integer number with possible values from 2³¹-1 to -2³¹. The value must be a valid number (consisting only of an optional sign (“+”/“-”) or “0”-“9”) and be in the range above. If the size of your value exceeds the limits above, you can try to use a Long or Double value instead. The default value is “0”.
- Long: An integer number with possible values from 2⁶ª-1 to -2⁶ª. The value must be a valid number (consisting only of an optional sign (“+”/“-”) or “0”-“9”) and be in the range above. The default value is “0”.
-
Double: A floating point decimal number with possible values from around 4.9·10⁻³²⁴ to 1.8·10³⁰⁸ in both the positive and negative range. The value must be a valid number (consisting only of an optional sign (“+”/“-”) or “0”-“9”). You can specify an exponent by appending “e” followed by the exponent. Apart from a numeric value you can also specify one of the following three (case-sensitive) special values:
- Infinity for positive infinity
- -Infinity for negative infinity
- NaN for “Not a Number”
- Boolean: A boolean value, either “true” or “false”. The default value is “false”. Any value that is not equal (ignoring case) to 'true' will be treated as false.
Options
Popular Successors
- DB Query Reader4 %
- String Manipulation (Variable)3 %
- Merge Variables3 %
- String to Path (Variable)3 %
Row Filter (deprecated)3 %- Column Expressions (legacy)2 %
- Excel Reader2 %
- Variable Expressions (legacy)2 %
- Rule-based Row Filter1 %
- Google Sheets Updater1 %
- Table Creator1 %
- Math Formula1 %
- Excel Writer1 %
- String Manipulation1 %
- Rule Engine1 %
- Rule Engine Variable1 %
- Google Sheets Reader1 %
- Constant Value Column< 1 %
- Try (Variable Ports)< 1 %
- Table Row to Variable< 1 %
- Java Edit Variable< 1 %
- DB Table Selector< 1 %
- DB SQL Executor< 1 %
- Variable to Table Column< 1 %
- Microsoft SQL Server Connector< 1 %
- Java Snippet< 1 %
- Oracle Connector< 1 %
- CASE Switch End< 1 %
- DB Writer< 1 %
- DB Connector< 1 %
- Configurable End IF/CASE< 1 %
Column Rename< 1 %- Variable to Credentials< 1 %
- GroupBy< 1 %
- Math Formula (Variable)< 1 %
- String Input (legacy)< 1 %
- SharePoint Online Connector< 1 %
Database Reader< 1 %- CSV Reader< 1 %
- File Reader< 1 %
Counting Loop Start< 1 %- X-Partitioner< 1 %
- Column Filter< 1 %
- Empty Table Switch< 1 %
- Send Email< 1 %
- Start WebDriver< 1 %
- Variable to Table Row< 1 %
- Table Row to Variable Loop Start< 1 %
- External Tool< 1 %
- List Files/Folders< 1 %
- Read Variables< 1 %
- Wait...< 1 %
- Catch Errors (Var Ports)< 1 %
File Reader< 1 %- Cell Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
CASE Switch Variable (Start)< 1 %- SQLite Connector< 1 %
- Credentials Configuration< 1 %
- Double Configuration< 1 %
- Single Selection Configuration< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Value Selection Widget< 1 %
- Credentials Validate Test< 1 %
- Date&Time-based Row Filter< 1 %
- Message Slack User< 1 %
- Inject Variables (Data)< 1 %
- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop Start< 1 %- Column Name Extractor< 1 %
- Filter Apply< 1 %
- Joiner< 1 %
- Pie Chart< 1 %
- Scatter Plot< 1 %
- Conda Environment Propagation< 1 %
- DB Query< 1 %
- Generic Web Service Client< 1 %
- Delete Files/Folders< 1 %
- String to Path< 1 %
Google Authenticator (Deprecated)< 1 %- Google Sheets Connector< 1 %
- Date&Time Configuration< 1 %
- Local File Browser Configuration< 1 %
- Credentials Input (legacy)< 1 %
- Table to JSON< 1 %
- Moving Average< 1 %
- Workflow Input< 1 %
- XLS Control Table from Cell Range< 1 %
Flow Variable End IF< 1 %- Write To Excel Template (deprecated)< 1 %
- Breakpoint< 1 %
- CSV Writer< 1 %
- Variable Creator< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- Column Renamer< 1 %
- Pivot< 1 %
- RowID< 1 %
- Table Transposer< 1 %
- Rule-based Row Splitter< 1 %
- CASE Switch Start< 1 %
- IF Switch< 1 %
- Data Generator< 1 %
- Line Plot< 1 %
- Workflow Executor< 1 %
- DB Row Filter< 1 %
- Math Formula (Multi Column)< 1 %
- Read Excel Sheet Names< 1 %
- Java Edit Variable (simple)< 1 %
- Path to String (Variable)< 1 %
- Boolean Widget< 1 %
- Slider Widget< 1 %
- Text Output Widget (legacy)< 1 %
- Container Input (Variable)< 1 %
- JSON Transformer< 1 %
- Python Script (legacy)< 1 %
- R Snippet< 1 %
- GET Request< 1 %
- PUT Request< 1 %
- Webpage Retriever< 1 %
Date&Time Shift< 1 %- OAuth Connector< 1 %
- WebDriver Factory< 1 %
- Space Connector< 1 %
- Message Slack channel< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Configurable IF/CASE Switch< 1 %
- Random Numbers Generator< 1 %
- Open in Matlab< 1 %
- Create Firefox Browser Instance< 1 %
- URL to File Path (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
- Create File Name (legacy)< 1 %
- Table Column to Variable< 1 %
- Extract Context Properties< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Table Writer< 1 %
- Loop End< 1 %
- Loop End (Column Append)< 1 %
- Interval Loop Start< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Variable Condition Loop End< 1 %
- Variable Loop End< 1 %
Variable Loop End< 1 %- Linear Regression Learner< 1 %
- PCA Apply< 1 %
- Concatenate< 1 %
- Auto-Binner< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- Lag Column< 1 %
- Column Name Replacer< 1 %
- Column Resorter< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Splitter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Table Manipulator< 1 %
- Table Partitioner< 1 %
- Missing Value< 1 %
- Row Aggregator< 1 %
- Numeric Row Splitter< 1 %
- Row Sampler< 1 %
- Sorter< 1 %
Column Splitter< 1 %- String Replacer< 1 %
- Cell Updater< 1 %
- Renderer to Image< 1 %
- Data Explorer< 1 %
- One-way ANOVA< 1 %
CASE Switch Data (Start)< 1 %- Bar Chart< 1 %
- Heatmap< 1 %
- Statistics View< 1 %
- Parquet Reader< 1 %
- Parquet Writer< 1 %
- Capture Workflow Start< 1 %
- Amazon Authenticator< 1 %
- Google BigQuery Connector< 1 %
- MySQL Connector< 1 %
- PostgreSQL Connector< 1 %
- Snowflake Connector< 1 %
- DB Insert< 1 %
- DB Reader< 1 %
- DB Query Injector< 1 %
- DB Table Creator< 1 %
- Empty Table Creator< 1 %
- Line Plot (Plotly)< 1 %
- Radar Plot (Plotly)< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- Tika Parser< 1 %
- Local File System Connector< 1 %
- Create File/Folder Variables< 1 %
- Create Folder< 1 %
- Create Temp Folder< 1 %
- Transfer Files< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Writer< 1 %
- Integer Configuration< 1 %
- String Configuration< 1 %
- File Download (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Tile View (JavaScript) (legacy)< 1 %
- Date&Time Widget< 1 %
- File Upload Widget< 1 %
- String Widget< 1 %
- File Download Widget< 1 %
- Multiple Selection Widget< 1 %
- Single Selection Widget< 1 %
- Container Input (Table)< 1 %
- JSON Reader< 1 %
- Container Input (JSON)< 1 %
- JSON Path< 1 %
- MongoDB Reader< 1 %
- Parameter Optimization Loop Start< 1 %
- Python Source (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- R to Table< 1 %
- POST Request< 1 %
- SAP Reader (Theobald Software)< 1 %
Date&Time Difference< 1 %Date&Time to String< 1 %String to Date&Time< 1 %Create Date&Time Range< 1 %- Date&Time Part Extractor< 1 %
Call Local Workflow (Row Based)< 1 %- Call Workflow (Table Based)< 1 %
Call Workflow Service< 1 %- Call Workflow Service< 1 %
- Column to XML< 1 %
- XML Reader< 1 %
- HTTP Retriever< 1 %
Loop End< 1 %- Value Counter< 1 %
Merge Variables< 1 %- H2O Generalized Linear Model Learner (Regression)< 1 %
- Value Selection Configuration< 1 %
- XPath< 1 %
- R Snippet< 1 %
Interval Loop Start< 1 %- Double to Integer< 1 %
- Row Filter (Labs)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Variable (End)< 1 %- Keras Activity Regularization Layer< 1 %
- Text Output (legacy)< 1 %
- Integer Widget< 1 %
- List Box Widget< 1 %
- SubGraph Extractor< 1 %
- Python View (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- ComplianceChecker< 1 %
IF Switch (Flow Variable Value)< 1 %List Files< 1 %Variable Condition Loop End< 1 %- RProp MLP Learner< 1 %
- Column Auto Type Cast< 1 %
- Missing Value (Apply)< 1 %
- Keras Input Layer< 1 %
Excel Reader (XLS)< 1 %Google Analytics Query (deprecated)< 1 %- Boolean Configuration< 1 %
- Integer Input (legacy)< 1 %
- String to JSON< 1 %
- JSON Schema Validator< 1 %
- MongoDB Writer< 1 %
- Testflow Configuration< 1 %
Modify Date< 1 %- Neo4j Reader< 1 %
- XLS Font Formatter< 1 %
- XLS Sheet Selector< 1 %
- KNIME Server Connector< 1 %
- Database To Variable (Legacy)< 1 %
- Write Variables< 1 %
- Load Local XML Files< 1 %
- R Plot< 1 %
- Get SP AccessToken as String< 1 %
- Labeling View< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- HTTPS Connection (legacy)< 1 %
- String to URI< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %CSV Writer< 1 %- Line Reader< 1 %
Model Writer< 1 %Generic Loop Start< 1 %- Cluster Assigner< 1 %
- DBSCAN< 1 %
- Logistic Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
- SVM Learner< 1 %
- Add Empty Rows< 1 %
- Column Combiner< 1 %
- Linear Correlation< 1 %
- Table Structure Creator< 1 %
- Cross Joiner< 1 %
- Reference Column Filter< 1 %
- String to Number (PMML)< 1 %
- Set Operator< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Decision Tree to Ruleset< 1 %
- Numeric Outliers< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
Color Appender< 1 %- Save Workflow< 1 %
- HDFS Connector< 1 %
- Amazon S3 File Picker (legacy)< 1 %
- Parallel Chunk Start< 1 %
- Vertica Connector< 1 %
- DB Type Mapper< 1 %
- Parameterized DB Query Reader< 1 %
- DB Update< 1 %
- DB Sorter< 1 %
- DB Table Remover< 1 %
- DB Query Extractor< 1 %
- Keras Network Writer< 1 %
- Explorer Browser< 1 %
- H2O AutoML Learner (Regression)< 1 %
XLS Sheet Appender< 1 %- Send to Power BI< 1 %
- Document Data Assigner< 1 %
- Path to URI< 1 %
Google Authenticator (API Key)< 1 %- List Box Configuration (legacy)< 1 %
- Multiple Selection Configuration< 1 %
- Single Selection (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Double Widget< 1 %
- File Chooser Widget< 1 %
- Container Output (Table)< 1 %
- XML to JSON< 1 %
- MongoDB Aggregation< 1 %
- R Source (Table)< 1 %
- R Source (Workspace)< 1 %
- Salesforce SOQL< 1 %
- Table Difference Checker< 1 %
- Workflow Output< 1 %
XML Reader< 1 %- Google Address Geocoder< 1 %
Regex Extractor< 1 %Click< 1 %- Extract Text< 1 %
Views
- This node has no views
Workflows
[Bug] Date&Time Range with variablesKNIME Hub- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- Show all 994 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.