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 Predecessors
- Table Row to Variable17 %
- Single Selection Configuration10 %
- Single Selection Widget5 %
- Table Column to Variable5 %
- Merge Variables4 %
- Rule Engine Variable4 %
- String Manipulation (Variable)4 %
- Table Row to Variable Loop Start4 %
- Extract Table Dimension3 %
- Variable Creator2 %
- Math Formula (Variable)2 %
- Excel Writer2 %
- String Widget1 %
- Value Selection Widget1 %
- Variable Expressions1 %
- Boolean Configuration1 %
- Boolean Widget1 %
- String Configuration< 1 %
- Catch Errors (Var Ports)< 1 %
- Rule Engine< 1 %
- Path to String (Variable)< 1 %
- Extract Context Properties< 1 %
- Extract Variables (Data)< 1 %
- Single Selection (legacy)< 1 %
- CASE Switch Start< 1 %
- Java Edit Variable< 1 %
- Counting Loop Start< 1 %
- Catch Errors (Data Ports)< 1 %
- String Input (legacy)< 1 %
Table Row to Variable< 1 %- Column Selection Widget< 1 %
- Wait...< 1 %
- CASE Switch End< 1 %
- Column Filter< 1 %
- Integer Widget< 1 %
- String to Path (Variable)< 1 %
- Refresh Button Widget< 1 %
Flow Variable IF Switch< 1 %- String Manipulation< 1 %
Single Selection Input QuickForm (legacy)< 1 %- Date&Time Input (legacy)< 1 %
- GroupBy< 1 %
Table Column to Variable< 1 %- Value Selection Configuration< 1 %
- Concatenate< 1 %
- Row Filter< 1 %
- Run Garbage Collector< 1 %
- Integer Configuration< 1 %
- Recursive Loop Start< 1 %
Table Row To Variable Loop Start< 1 %- Group Loop Start< 1 %
- Boolean Input (legacy)< 1 %
Table Column to Variable< 1 %- Excel Reader< 1 %
- Generic Loop Start< 1 %
- Try (Variable Ports)< 1 %
- Table Transposer< 1 %
- CSV Writer< 1 %
Flow Variable End IF< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Constant Value Column< 1 %
- IF Switch< 1 %
- Text Output Widget (legacy)< 1 %
- File Upload Widget< 1 %
- RowID< 1 %
- End IF< 1 %
- Math Formula< 1 %
- Variable to Table Row< 1 %
- Variable Loop End< 1 %
- Container Input (Variable)< 1 %
- Table Creator< 1 %
Generic Loop Start< 1 %Excel Reader (XLS)< 1 %- Text Output (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Date&Time Difference< 1 %
- Rule-based Row Filter< 1 %
- Value Selection (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
Recursive Loop Start (2 ports)< 1 %- Column Aggregator< 1 %
- Reference Row Filter< 1 %
- Joiner< 1 %
Column Rename< 1 %- Parameter Optimization Loop Start< 1 %
- Active Branch Inverter< 1 %
- Cross Joiner< 1 %
- Paired t-test< 1 %
- Double Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Create Date&Time Range< 1 %
Extract Outer/InnerHTML< 1 %- Breakpoint< 1 %
- Column Selection Configuration< 1 %
- String to Date&Time< 1 %
- Catch Errors (Generic Ports)< 1 %
Table Row to Variable< 1 %CSV Reader< 1 %- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Variable (Start)< 1 %- Integer Input (legacy)< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (Start)< 1 %- Counter Generation< 1 %
- Date&Time Configuration< 1 %
- Local File Browser Configuration< 1 %
- Double Widget< 1 %
Container Input (Variable)< 1 %- CSV Reader< 1 %
- Sorter< 1 %
- Column Expressions< 1 %
- GET Request< 1 %
- Date&Time Widget< 1 %
- DB Transaction End< 1 %
- URL to File Path (Variable)< 1 %
Database Reader< 1 %Merge Variables< 1 %- Java Edit Variable (simple)< 1 %
String Input (legacy)< 1 %- Java Snippet< 1 %
Interval Loop Start< 1 %Column Appender< 1 %- DB Writer< 1 %
- Credentials Configuration< 1 %
- Credentials Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Add Empty Rows< 1 %
- Reference Column Resorter< 1 %
CASE Switch Data (End)< 1 %- URI Port to Variable< 1 %
Loop End (2 ports)< 1 %Joiner< 1 %Excel Writer (XLS)< 1 %- Double Input (legacy)< 1 %
Variable to Table Row< 1 %- Fixed Width File Reader< 1 %
Table Writer< 1 %- Column Name Extractor< 1 %
- Duplicate Row Filter< 1 %
- Ungroup< 1 %
- Read Variables< 1 %
- Variable to Table Column< 1 %
- SDF Reader< 1 %
- String to Path< 1 %
- Create Temp Folder< 1 %
- Container Input (JSON)< 1 %
- Copy/Move Files (legacy)< 1 %
Database Writer< 1 %Recursive Loop Start< 1 %- Multiple Selections (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
File Reader< 1 %- Column Resorter< 1 %
Excel Sheet Appender (XLS)< 1 %Variable Condition Loop End< 1 %- Column Appender< 1 %
- Lag Column< 1 %
- Java Snippet (simple)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %Loop End< 1 %Counting Loop Start< 1 %Cell Splitter< 1 %Number To String< 1 %- Cache< 1 %
- List Box Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
Boolean Input (legacy)< 1 %Value Selection QuickForm (legacy)< 1 %- R Snippet< 1 %
- XPath< 1 %
- Upload as LiveDesign Model< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Table Row To Variable Run-to-time Loop Start< 1 %
- Create Directory (legacy)< 1 %
- Upload (legacy)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
CSV Writer< 1 %Database SQL Executor< 1 %PMML Reader< 1 %Table Reader< 1 %Recursive Loop End (2 ports)< 1 %- Decision Tree Learner< 1 %
- Column Rename (Regex)< 1 %
- Row Splitter< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
- Independent groups t-test< 1 %
- Empty Table Switch< 1 %
- Create Temp Dir (legacy)< 1 %
- Extract Table Spec< 1 %
- PMML to Cell< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Google Sheets Updater< 1 %
- Column Filter Configuration< 1 %
- CSS Editor< 1 %
- Value Filter Definition (legacy)< 1 %
- Slider Input (legacy)< 1 %
- JSON to Table< 1 %
- Parameter Optimization Loop End< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- POST Request< 1 %
- Substructure Search< 1 %
- Try (Data Ports)< 1 %
- Image Writer (Port)< 1 %
- String to Number< 1 %
- Row Filter (Labs)< 1 %
- Pivot< 1 %
- Rule-based Row Splitter< 1 %
- Autocomplete Text Widget< 1 %
- Create Folder< 1 %
- List Files/Folders< 1 %
- Files/Folders Meta Info< 1 %
- Google Sheets Connector< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Slider Widget< 1 %
- Multiple Selection Widget< 1 %
- Container Output (JSON)< 1 %
- MongoDB Update< 1 %
- Python Script (legacy)< 1 %
- R Source (Table)< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- RDKit Canon SMILES< 1 %
Views
- This node has no views
Workflows
justknimeit-27KNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 00 Data GenerationKNIME Hub
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 1998 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.