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
- Single Selection Configuration5 %
- Table Row to Variable5 %
- Single Selection Widget4 %
- Rule Engine Variable4 %
- String Manipulation (Variable)4 %
- Merge Variables3 %
- Extract Table Dimension3 %
- Table Row to Variable Loop Start3 %
- Variable Creator2 %
- Path to String (Variable)1 %
Table Row to Variable1 %- Math Formula (Variable)1 %
- Catch Errors (Data Ports)1 %
- Variable Expressions1 %
- Boolean Configuration1 %
- String Widget1 %
- Table Column to Variable1 %
Flow Variable IF Switch1 %Single Selection Input QuickForm (legacy)1 %- Boolean Widget1 %
- Extract Variables (Data)< 1 %
- Rule Engine< 1 %
Table Column to Variable< 1 %- Run Garbage Collector< 1 %
Table Row To Variable Loop Start< 1 %- Boolean Input (legacy)< 1 %
Table Column to Variable< 1 %- CASE Switch End< 1 %
- Catch Errors (Var Ports)< 1 %
- Table Transposer< 1 %
- GroupBy< 1 %
- CSV Writer< 1 %
Flow Variable End IF< 1 %- Constant Value Column< 1 %
- Integer Widget< 1 %
- Text Output Widget (legacy)< 1 %
- Value Selection Widget< 1 %
- CASE Switch Start< 1 %
- File Upload Widget< 1 %
- RowID< 1 %
- End IF< 1 %
- Date&Time Input (legacy)< 1 %
- Excel Writer< 1 %
- Table Creator< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %Column Rename< 1 %- String Manipulation< 1 %
Excel Reader (XLS)< 1 %- Text Output (legacy)< 1 %
- Wait...< 1 %
- IF Switch< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Column Filter< 1 %
- Value Selection (legacy)< 1 %
Recursive Loop Start (2 ports)< 1 %- Column Aggregator< 1 %
- Reference Row Filter< 1 %
- String Configuration< 1 %
- Counting Loop Start< 1 %
- Rule-based Row Filter< 1 %
- Math Formula< 1 %
- Single Selection (legacy)< 1 %
- Parameter Optimization Loop Start< 1 %
- Active Branch Inverter< 1 %
- Group Loop Start< 1 %
- Cross Joiner< 1 %
- Paired t-test< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Create Date&Time Range< 1 %
Extract Outer/InnerHTML< 1 %- Breakpoint< 1 %
- Variable to Table Row< 1 %
- Column Expressions< 1 %
- Column Selection Configuration< 1 %
- String to Date&Time< 1 %
- Generic Loop Start< 1 %
- Container Input (Variable)< 1 %
- Catch Errors (Generic Ports)< 1 %
- Try (Variable Ports)< 1 %
Table Row to Variable< 1 %CSV Reader< 1 %- Java Edit Variable< 1 %
- Column List Loop Start< 1 %
- Concatenate< 1 %
Row Filter (deprecated)< 1 %- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Variable (Start)< 1 %- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (Start)< 1 %- Counter Generation< 1 %
- Date&Time Configuration< 1 %
- Local File Browser Configuration< 1 %
- Value Selection Configuration< 1 %
- Double Widget< 1 %
- Column Selection Widget< 1 %
Container Input (Variable)< 1 %- Extract Context Properties< 1 %
- CSV Reader< 1 %
- Variable Loop End< 1 %
- Column Appender< 1 %
- Joiner< 1 %
- Sorter< 1 %
- Excel Reader< 1 %
- String to Path (Variable)< 1 %
- Refresh Button Widget< 1 %
- GET Request< 1 %
- Recursive Loop Start< 1 %
- Date&Time Widget< 1 %
- Date&Time Difference< 1 %
- DB Transaction End< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Configurable End IF/CASE< 1 %
- Google Sheets Writer< 1 %
- Table to HTML String< 1 %
- String Manipulation (Multi Column)< 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 %- 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 %
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 (deprecated)< 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- !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 2384 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.