This node takes a list of user-defined rules and tries to match them
to the defined flow variables. If a rule matches, its outcome value
will become the value of the flow variable.
The first matching rule will determine the outcome.
Each rule is represented by a line.
To add comments, start a line with
//
(comments can not be placed in the same line as a rule). Anything after // will not be interpreted as a rule.
Rules consist of a condition part (antecedent), which must
evaluate to
true
or
false
, and an outcome (consequent, after the => symbol) which is put into
the new flow variable if the rule matches.
The outcome of a rule can either be a constant string, a constant number or boolean constant, or a reference to a flow variable value. The type of the outcome column is the common super type of all possible outcomes (including the rules that can never match). If no rule matches, the outcome is "", 0, or 0.0 depending on the output type.
Numbers are given in the usual decimal representation. Note that
strings must not contain (double-)quotes (for those cases use the following syntax: /Oscar Wilde's wisdom: "Experience is simply the name we give our mistakes."/). The flow variables are
represented by
$${
TypeCharacterAndFlowVarName
}$$
.
The TypeCharacter should be 'D' for double (real) values, 'I' for
integer values and 'S' for strings.
The logical expressions can be grouped with parentheses. The
precedence rules for them are the following: NOT binds most, AND,
XOR and finally OR the least.
Comparison operators always take
precedence over logical connectives.
All operators (and their names)
are case-sensitive.
Some example rules (each should be in one line):
// This is a comment
$${DFlowVar0}$$ > 0 => "Positive"
FlowVar0 has value above zero, which case the result flow variable
has the value Positive.
$${SFlowVar0}$$ = "Active" AND
$${IFlowVar1}$$ <= 5 => "Outlier"
When FlowVar0 is "Active" and FlowVar1 is greater or equal to 5, then
the result is Outlier.
$${SFlowVar0}$$ LIKE "Market Street*" AND
($${SFlowVar1}$$ IN ("married", "divorced")
OR $${IFlowVar2}$$ > 40) => "Strange"
The logical connectives help express complex conditions.
$${SFlowVar10}$$ MATCHES $${SFlowVar0}$$ OR $${DFlowVar2}$$ < $${IFlowVar1}$$ =>
$${SFlowVar0}$$
You can compare different flow variables.
You can use either Ctrl+Space to insert predefined parts, or select them from the upper controls.
The NaNs equal to other NaN values (other values are neither less, nor greater or equal to NaN values).
Options
Popular Successors
- CASE Switch Start13 %
- IF Switch13 %
- String Manipulation (Variable)3 %
- Merge Variables3 %
- Rule Engine Variable2 %
Recursive Loop End2 %- Rule Engine1 %
- Variable to Table Row1 %
Row Filter (deprecated)1 %- Variable Condition Loop End1 %
- CASE Switch End1 %
- Breakpoint< 1 %
CSV Writer< 1 %- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- String Manipulation< 1 %
- Send Email< 1 %
- Rule-based Row Filter< 1 %
- Math Formula (Variable)< 1 %
- Variable to Table Column< 1 %
- DB Query Reader< 1 %
- Try (Variable Ports)< 1 %
Random Forest Learner< 1 %- Joiner< 1 %
- Configurable IF/CASE Switch< 1 %
CASE Switch Variable (End)< 1 %- Text Output Widget (legacy)< 1 %
- Table Creator< 1 %
CASE Switch Variable (Start)< 1 %- Inject Variables (Data)< 1 %
Flow Variable End IF< 1 %Database SQL Executor< 1 %Generic Loop Start< 1 %- Excel Writer< 1 %
- String to Path (Variable)< 1 %
Flow Variable IF Switch< 1 %Loop End< 1 %- Constant Value Column< 1 %
- Table Transposer< 1 %
- Variable Expressions< 1 %
- R Snippet< 1 %
- Variable Creator< 1 %
- URL to File Path (Variable)< 1 %
- Java Edit Variable< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- Pivot< 1 %
Column Rename< 1 %- Row Sampling< 1 %
- Column Splitter< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- DB Query< 1 %
- Date&Time Shift< 1 %
IF Switch (Flow Variable Value)< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Writer< 1 %- CSV Reader< 1 %
Variable Condition Loop End< 1 %- k-Means< 1 %
Row Splitter (deprecated)< 1 %- Statistics< 1 %
- Amazon Redshift Connector< 1 %
- Multiple Selection Configuration< 1 %
- Single Selection Widget< 1 %
- Python Script (legacy)< 1 %
- GET Request< 1 %
- XPath< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Counting Loop Start< 1 %
- PCA< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- DB Table Selector< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Google Sheets Writer< 1 %
- Date&Time Configuration< 1 %
- Date&Time-based Row Filter< 1 %
Database IF Switch< 1 %- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Catch Errors (Generic Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
Database Table Connector< 1 %Database Connector< 1 %Database Drop Table< 1 %- Chunk Loop Start< 1 %
- Column Appender< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
MySQL Connector< 1 %- Microsoft SQL Server Connector< 1 %
- Oracle Connector< 1 %
- Excel Reader< 1 %
- Delete Files/Folders< 1 %
- Google Sheets Updater< 1 %
- String Input (legacy)< 1 %
- String Widget< 1 %
- Refresh Button Widget< 1 %
- Multiple Selection Widget< 1 %
- Create Date&Time Range< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Read Variables< 1 %
- Wait...< 1 %
- Active Branch Inverter< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
- Variable to Credentials< 1 %
Variable to Table Row< 1 %Database Reader< 1 %- CSV Writer< 1 %
- Table Reader< 1 %
- Table Writer< 1 %
List Files< 1 %Table Reader< 1 %- Java Snippet< 1 %
- Loop End< 1 %
- Loop End (Column Append)< 1 %
- Group Loop Start< 1 %
- Recursive Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
Variable Loop End< 1 %- Tree Ensemble Learner< 1 %
- Random Forest Learner< 1 %
- Distance Matrix Pair Extractor< 1 %
- Concatenate< 1 %
- Cell Splitter< 1 %
- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Reference Row Filter< 1 %
- Table Manipulator< 1 %
- String Splitter (Regex)< 1 %
- Sorter< 1 %
- Top k Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
CASE Switch Model (Start)< 1 %- Empty Table Switch< 1 %
- End IF< 1 %
- Cache< 1 %
Merge Variables< 1 %- Color Manager< 1 %
- PostgreSQL Connector< 1 %
- DB Connector< 1 %
- DB SQL Executor< 1 %
- Counter Generation< 1 %
- Keras Input Layer< 1 %
- Bar Chart (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
- Column Expressions< 1 %
- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- Strings to Document< 1 %
- Create File/Folder Variables< 1 %
- List Files/Folders< 1 %
- Credentials Configuration< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- String Configuration< 1 %
- CSS Editor< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Date&Time Widget< 1 %
- Slider Widget< 1 %
- File Download Widget< 1 %
- Python Edit Variable (legacy)< 1 %
- POST Request< 1 %
- Date&Time to String< 1 %
- Moving Average< 1 %
- Copy/Move Files (legacy)< 1 %
- Create Directory (legacy)< 1 %
- Inject Variables (Database)< 1 %
Variable to Table Row< 1 %Extract Context Properties< 1 %File Reader< 1 %Counting Loop Start< 1 %- X-Partitioner< 1 %
Scorer< 1 %- Random Forest Predictor (Regression)< 1 %
- Bootstrap Sampling< 1 %
- String to Number< 1 %
- Reference Column Filter< 1 %
- H2O Generalized Linear Model Learner< 1 %
- Math Formula (Multi Column)< 1 %
- Double Input (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Python Source (legacy)< 1 %
- Python View (legacy)< 1 %
- Random Numbers Generator< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %CSV Reader< 1 %- Feature Selection Filter< 1 %
Loop End (2 ports)< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Table Validator< 1 %
- RowID< 1 %
- DB Row Filter< 1 %
- Index Query< 1 %
Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Value Selection Configuration< 1 %
MongoDB Reader< 1 %- R to R< 1 %
- Moving Aggregator< 1 %
XGBoost Tree Ensemble Learner (Regression)< 1 %- Active Learning Loop End< 1 %
- Try (Data Ports)< 1 %
Database Query< 1 %Database Row Filter< 1 %Model Writer< 1 %- Feature Selection Loop End< 1 %
- Logistic Regression Learner< 1 %
Cell Replacer< 1 %Column Appender< 1 %- Cross Joiner< 1 %
- String Manipulation (Multi Column)< 1 %
- Unpivot< 1 %
- MySQL Connector< 1 %
- TimeDelay Loop End< 1 %
- Send to Power BI< 1 %
Google Authenticator (Deprecated)< 1 %- Google Sheets Appender< 1 %
- Local File Browser Configuration< 1 %
- Single Selection Configuration< 1 %
- Generic JavaScript View (JavaScript)< 1 %
Container Input (Variable)< 1 %- Container Output (Table)< 1 %
MongoDB Writer< 1 %- MongoDB Reader< 1 %
Python Source< 1 %- Python Learner (legacy)< 1 %
Python Script (1⇒2)< 1 %- R View (Table)< 1 %
- String to Date&Time< 1 %
- Window Loop Start< 1 %
- Extract Time Window (legacy)< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Fingerprint< 1 %
- XLS Control Table from Cell Range< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
IF Switch (Flow Variable Value)< 1 %Database IF Switch (Flow Variable Value)< 1 %- Write Variables< 1 %
- List Folders< 1 %
- Range Filter< 1 %
- ARIMA Learner< 1 %
Binary Objects to Files< 1 %- Binary Objects to Strings< 1 %
- List Remote Files (legacy)< 1 %
- String to URI< 1 %
- Unzip Files (legacy)< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
- Extract Variables (Database)< 1 %
- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %Database Connection Table Writer< 1 %SQL Inject< 1 %Database Table Selector< 1 %- Model Reader< 1 %
Recursive Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %Recursive Loop Start< 1 %- Decision Tree Learner< 1 %
- Linear Regression Learner< 1 %
- Numeric Scorer< 1 %
- SVM Learner< 1 %
- Tree Ensemble Predictor< 1 %
- Simple Regression Tree Learner< 1 %
- Add Empty Rows< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
- Number to String< 1 %
String To Number< 1 %- Column Aggregator< 1 %
- Column Resorter< 1 %
- Domain Calculator< 1 %
- Duplicate Row Filter< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Denormalizer< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Value Counter< 1 %
- Ruleset to Table< 1 %
- Odds and Risk Ratios< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Crosstab< 1 %
Hive Connector< 1 %- PySpark Script (1 to 1)< 1 %
- Capture Workflow Start< 1 %
- Workflow Executor< 1 %
- SDF Reader< 1 %
Amazon Redshift Connector< 1 %H2 Connector< 1 %Microsoft SQL Server Connector< 1 %- DB Connection Closer< 1 %
- DB Merge< 1 %
- DB Reader< 1 %
- DB Writer< 1 %
- DB Column Filter< 1 %
- DB Table Creator< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- Random Number Assigner (Apache)< 1 %
- DL Python Network Learner< 1 %
- TensorFlow Network Reader< 1 %
- Autocomplete Text Widget< 1 %
- Cell to Model< 1 %
- Explorer Writer< 1 %
- H2O AutoML Learner (Regression)< 1 %
- OSM Map to Image< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- External SSH Tool< 1 %
- Java Snippet Row Splitter< 1 %
- String Matcher< 1 %
- Case Converter< 1 %
Stop Word Filter< 1 %- Stop Word Filter< 1 %
- Weka Predictor (3.7)< 1 %
- Path to String (Variable)< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- File Download (legacy)< 1 %
- Text Output (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- File Upload Widget< 1 %
- Integer Widget< 1 %
- Column Selection Widget< 1 %
- JSON Path< 1 %
JSON Writer< 1 %- Image Cropper< 1 %
- SHAP Loop Start< 1 %
- Parameter Optimization Loop End< 1 %
Python Script (1⇒1)< 1 %Double Input (legacy)< 1 %- Add Table to R< 1 %
- R Source (Table)< 1 %
- Modify Time Zone< 1 %
- Date/Time Shift (legacy)< 1 %
- Twitter Search< 1 %
- Substructure Search< 1 %
- HTTP Retriever< 1 %
- WebDriver Factory< 1 %
- Find Elements< 1 %
- Get Pooled WebDriver< 1 %
- Wait< 1 %
Views
- This node has no views
Workflows
justknimeit-27KNIME Hub- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- Show all 2385 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
- No “Flow Variable Creator” node?by qqilihq on 2019-08-06forum.knime.com/p/67197
- Run Email based on conditional valueby armingrudd on 2019-09-05forum.knime.com/p/69449
- repetition of a specific field in the workflow if it does not reach the desired number of databy armingrudd on 2019-06-27forum.knime.com/p/63200
- How to create a path to save file to my USB stickby qqilihq on 2019-07-15forum.knime.com/p/65414
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.