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 column if the rule matches.
The outcome of a rule can either be a constant string, a constant number or boolean constant. 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 a missing value.
Columns are given by their name surrounded by $, numbers are given in the usual decimal representation. Note that strings must not contain (double-)quotes.
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 $Col0$ > 0 => "Positive"When the values in Col0 are greater than 0, we assign Positive to the result column value (if no previous rule matched).
$Col0$ = "Active" AND $Col1$ <= 5 => "Outlier"You can combine conditions.
You can use either Ctrl+Space to insert predefined parts, or select them from the upper controls.
Options
Popular Successors
- Decision Tree to Ruleset5 %
PMML Writer4 %- CASE Switch Start3 %
- Color Manager3 %
Scorer3 %Excel Writer (XLS)3 %- CSV Writer2 %
- Column Filter (PMML)2 %
- Rule Viewer (local) (Legacy)2 %
- Ruleset Predictor2 %
- Ruleset to Table1 %
- Statistics1 %
- Scatter Matrix (legacy)1 %
- Excel Writer1 %
- Number to Category (Apply)1 %
- Lag Column1 %
Column Rename1 %- PMML Writer1 %
- Decision Tree Learner1 %
String To Number1 %- Column Filter1 %
- Ruleset Editor1 %
- IF Switch1 %
- Conditional Box Plot (legacy)1 %
- Interactive Table (legacy)1 %
- PMML to SQL1 %
- PMML to Cell1 %
Excel Writer (XLS)1 %- JPMML Classifier1 %
- Loop End< 1 %
- Chunk Loop Start< 1 %
- Column Combiner< 1 %
- Category to Number (Apply)< 1 %
Linear Correlation< 1 %Row Filter (deprecated)< 1 %- GroupBy< 1 %
- Joiner< 1 %
- Partitioning< 1 %
- Missing Value (Apply)< 1 %
- String Manipulation< 1 %
- Rule Engine< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Math Formula< 1 %
XLS Writer< 1 %XML Writer< 1 %- Concatenate< 1 %
- Number to String< 1 %
- Missing Value< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
- Empty Table Switch< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Database Writer< 1 %Model Writer< 1 %Recursive Loop End< 1 %- k-Means< 1 %
- Association Rule Learner< 1 %
Column Appender< 1 %- One to Many< 1 %
- Constant Value Column< 1 %
Joiner< 1 %- Rule-based Row Filter< 1 %
- Table to JSON< 1 %
CSV Writer< 1 %Database Apply-Binner< 1 %- Java Snippet< 1 %
- X-Partitioner< 1 %
- Fuzzy Rule Predictor< 1 %
- Cluster Assigner< 1 %
- Scorer< 1 %
- Random Forest Learner< 1 %
- PMML Model Appender< 1 %
- PMML Transformation Appender< 1 %
Number To String< 1 %- Nominal Value Row Filter< 1 %
String To Number (PMML)< 1 %- Box Plot (legacy)< 1 %
- PMML Predictor< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- Bar Chart (JFreeChart)< 1 %
- ROC Curve (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- String to Date/Time (legacy)< 1 %
- Plate Heatmap Viewer< 1 %
PMML Reader< 1 %Loop End< 1 %- Group Loop Start< 1 %
- Recursive Loop End< 1 %
- Fuzzy Rule Learner< 1 %
- Decision Tree Predictor< 1 %
- RProp MLP Learner< 1 %
PCA< 1 %- Linear Regression Learner< 1 %
- Entropy Scorer< 1 %
- Gradient Boosted Trees Learner< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
Cell Replacer< 1 %- Column Auto Type Cast< 1 %
- Column Aggregator< 1 %
- Column Merger< 1 %
- Cross Joiner< 1 %
- Duplicate Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Pivot< 1 %
- Many to One (PMML)< 1 %
- One to Many (PMML)< 1 %
- Denormalizer (PMML)< 1 %
Number To String (PMML)< 1 %- String to Number (PMML)< 1 %
- XML to PMML< 1 %
- Sorter< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Rank Correlation< 1 %- Single sample t-test< 1 %
- Extract Table Spec< 1 %
- Crosstab< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Spark Transformations Applier< 1 %
- One Rule Inserter< 1 %
PMML Predictor< 1 %- Cell to Model< 1 %
- Pie Chart (JFreeChart)< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Radar Plot Appender< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Rowset Filter< 1 %
Python Script (2⇒1)< 1 %- PMML Difference Checker< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- XPath< 1 %
Views
- This node has no views
Workflows
Links
- No links available
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.