It takes a list of user-defined rules from the second input port (from the selected column(s)) and tries to match them to each row in the input table. If a rule matches, its outcome value is added into a new column. The first matching rule in order of definition determines the outcome.
Each rule is represented by a row, new line characters are replaced by spaces, even in string constants.
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 column if the rule matches.
The outcome of a rule may be any of the following: a string (between quotes
" or /), a number, a boolean constant, a reference to another column or the value of
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 a missing value unless a default value
is specified.
Columns are given by their name surrounded by $, numbers are given in the usual decimal representation. Note that strings must not contain (double-) quotes. Flow variables are represented by $${TypeCharacterAndFlowVarName}$$. (Column references are not supported for PMML outputs.) 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.
The
ROWID
represents the row key string, the
ROWINDEX
is the index of the row (first row has
0
value), while
ROWCOUNT
stands for the number of rows in the table. (These are not available for PMML.)
Some example rules (each should be in one row):
// 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.
$Col0$ LIKE "Market Street*" AND
($Col1$ IN ("married", "divorced")
OR $Col2$ > 40) => "Strange"
$Col0$ MATCHES $${SFlowVar0}$$ OR $$ROWINDEX$$ < $${IFlowVar1}$$ =>
$Col0$
With parentheses you can combine multiple conditions. The result in the second case comes from one of the
columns.
$Col0$ > 5 => $${SCol1}$$
The result can also come from a flow variable.
The following comparisons result true (other values are neither less, nor greater or equal to missing and NaN values):
- ? =,<=,>= ?
- NaN =,<=,>= NaN
Options
Settings
PMML
Popular Successors
- Rule Engine6 %
- Joiner4 %
Row Filter (deprecated)3 %- Rule Engine (Dictionary)3 %
- Concatenate3 %
- GroupBy3 %
Loop End2 %CSV Writer2 %- Column Filter2 %
- Rule Engine Variable (Dictionary)2 %
- Loop End2 %
- Reference Row Filter1 %
- String Manipulation1 %
Column Rename1 %- String to Date&Time1 %
Row Splitter (deprecated)1 %String To Number1 %- Excel Writer1 %
- XLS Control Table Generator1 %
Recursive Loop End1 %Cell Replacer1 %- String to Number1 %
- Sorter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Variable to Table Column< 1 %- Column List Loop Start< 1 %
- Rule-based Row Filter< 1 %
- Math Formula< 1 %
- Date&Time-based Row Filter< 1 %
- RDKit From Molecule< 1 %
- Group Loop Start< 1 %
Scorer< 1 %- Column Renamer (Dictionary)< 1 %
- Partitioning< 1 %
- Pivot< 1 %
- Column Expressions< 1 %
- Table View (JavaScript)< 1 %
- PMML Writer< 1 %
- Table Writer< 1 %
- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- RowID< 1 %
- String Manipulation (Multi Column)< 1 %
- Value Counter< 1 %
- Extract Table Spec< 1 %
- DB Update< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Google Sheets Updater< 1 %
- String to Date/Time (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Table Row To Variable Loop Start< 1 %- CSV Writer< 1 %
- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
- Decision Tree Predictor< 1 %
- Auto-Binner< 1 %
- Cell Splitter< 1 %
Number To String< 1 %- Column Resorter< 1 %
- Constant Value Column< 1 %
- Duplicate Row Filter< 1 %
Joiner< 1 %- Missing Value< 1 %
String Replace (Dictionary)< 1 %- Table Transposer< 1 %
- Rule-based Row Splitter< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Color Manager< 1 %
- One Rule Inserter< 1 %
- Pie Chart (JFreeChart)< 1 %
- Data to Report (BIRT)< 1 %
- Moving Aggregator< 1 %
Recursive Loop Start (2 ports)< 1 %- Fuzzy Rule Learner< 1 %
- Column Aggregator< 1 %
- Extract Missing Value Cause< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
Excel Writer (XLS)< 1 %- Document Vector< 1 %
- Table Row to Variable< 1 %
Database Update< 1 %PMML Writer< 1 %- Scorer< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Splitter< 1 %
- Key-Collection HiLite Translator< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- String Splitter (Regex)< 1 %
- Ruleset to Table< 1 %
- Prediction Fusion< 1 %
XLS Writer< 1 %- Dictionary Filter< 1 %
- Table Difference Checker< 1 %
- Table Column to Variable< 1 %
- Silhouette Coefficient< 1 %
- Cell Splitter By Position< 1 %
- Number to String< 1 %
- Column Rename (Regex)< 1 %
- Set Operator< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Decision Tree to Ruleset< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
Color Appender< 1 %- DB Writer< 1 %
- Java Snippet Row Filter< 1 %
- Table Editor (JavaScript)< 1 %
- Table to JSON< 1 %
- Copy/Move Files (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %Database Writer< 1 %Table Writer< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %Random Forest Predictor< 1 %- Gradient Boosted Trees Learner< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Simple Regression Tree Predictor< 1 %
- PMML Transformation Appender< 1 %
Concatenate (Optional in)< 1 %- Numeric Binner< 1 %
- Create Bit Vector< 1 %
- Column Comparator< 1 %
Column Appender< 1 %- Column Appender< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Edit Nominal Domain< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Normalizer (PMML)< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- Column Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Ungroup< 1 %
- Ruleset Predictor< 1 %
- Rank Correlation< 1 %
- IF Switch< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Save Workflow< 1 %
DB Table Creator< 1 %- Stacked Area Chart (JavaScript)< 1 %
- Rule Viewer (local) (Legacy)< 1 %
Excel Sheet Appender (XLS)< 1 %- Excel Reader< 1 %
Send to Tableau Server (Hyper)< 1 %- String Matcher< 1 %
- Porter Stemmer< 1 %
- Dictionary Tagger< 1 %
Bag of Words Creator< 1 %- Strings to Document< 1 %
- Scorer (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
Python Script (1⇒1)< 1 %Extract Date&Time Fields< 1 %- Date&Time Shift< 1 %
- Modify Time< 1 %
- Date Field Extractor (legacy)< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
03_OpenSourceVizAndModelingKNIME Hub- 07 matching non matching stringsKNIME Hub
- 09_DataVisualization_AirlineDatasetKNIME Hub
- 09_DataVisualization_AirlineDatasetKNIME Hub
- 09_DataVisualization_AirlineDatasetKNIME Hub
- Show all 68 workflows
Links
- Alteryx to KNIME conversionby HansS on 2024-09-30forum.knime.com/p/270563
- Merge two datasets and have new column outputby armingrudd on 2020-03-10forum.knime.com/p/83878
- How to more elegantly replace strings in bulk using wildcards?by izaychik63 on 2020-06-08forum.knime.com/p/93752
- Rule Engine Auto Updateby AnotherFraudUser on 2020-05-21forum.knime.com/p/91997
- Rule Engine - keywords as variableby izaychik63 on 2023-06-19forum.knime.com/p/213555
- Show all 16 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.