Each rule is represented by a row.
To add comments, start a line in a (condition) cell 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 row):
// 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.
The NaNs equal to other NaN values (other values are neither less, nor greater or equal to NaN values).
Options
Popular Predecessors
Variable to Table Row8 %File Reader5 %- Rule Engine (Dictionary)5 %
Table Column to Variable4 %- Single Selection Configuration4 %
- Rule Engine3 %
- Rule Engine Variable (Dictionary)3 %
- Table Creator3 %
- Table Row to Variable Loop Start2 %
- Rule Engine Variable2 %
- Column Filter2 %
Table Row to Variable2 %CSV Reader2 %Cell Replacer2 %- Table Column to Variable2 %
- Table Row to Variable2 %
Table Row To Variable Loop Start1 %Counting Loop Start1 %- String Manipulation1 %
- String Manipulation (Variable)1 %
Excel Reader (XLS)1 %Excel Reader (XLS)1 %- DB Reader1 %
- Extract Variables (Data)1 %
Table Reader1 %Joiner1 %- Extract Table Dimension1 %
- Column List Loop Start1 %
- Rule-based Row Filter (Dictionary)1 %
- Math Formula1 %
Loop End< 1 %- Concatenate< 1 %
- String Input (legacy)< 1 %
Table Row to Variable< 1 %- Column Combiner< 1 %
- String to Date&Time< 1 %
- Variable Creator< 1 %
- Column Renamer (Dictionary)< 1 %
- Variable Expressions< 1 %
- Excel Reader< 1 %
Loop End (2 ports)< 1 %Column Appender< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %- Constant Value Column< 1 %
Row Filter (deprecated)< 1 %- Ungroup< 1 %
- Java Edit Variable (simple)< 1 %
- Line Reader< 1 %
- Column Comparator< 1 %
- Merge Variables< 1 %
- String Configuration< 1 %
- String to Date/Time (legacy)< 1 %
- Create Collection Column< 1 %
- Java Snippet< 1 %
Number To String< 1 %- Reference Row Filter< 1 %
- Sorter< 1 %
- Rule-based Row Splitter< 1 %
XLS Reader< 1 %Dictionary tagger< 1 %Variable to Table Column< 1 %- Extract Variables (Database)< 1 %
Variable to Table Row< 1 %- PNN Predictor< 1 %
- Association Rule Learner< 1 %
Cell Splitter< 1 %- GroupBy< 1 %
- RowID< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Rule-based Row Filter< 1 %
- Ruleset Editor< 1 %
Merge Variables< 1 %- SDF Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %- Dictionary Filter< 1 %
- Replacer< 1 %
- Value Selection Configuration< 1 %
- Boolean Input (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Single Selection (legacy)< 1 %
Container Input (Variable)< 1 %Extract Date&Time Fields< 1 %- XGBoost Predictor< 1 %
- Try (Variable Ports)< 1 %
- Variable to Table Column< 1 %
- Table Reader< 1 %
- Column Appender< 1 %
Row Splitter (deprecated)< 1 %- Joiner< 1 %
- String Manipulation (Multi Column)< 1 %
CASE Switch Variable (Start)< 1 %- Math Formula (Multi Column)< 1 %
- Path to String (Variable)< 1 %
- Nominal Row Filter Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- File Upload Widget< 1 %
- Date&Time to String< 1 %
Views
- This node has no views
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.