TRUE outcome, the row will be selected for inclusion. Otherwise (i.e. if the first matching rule yields FALSE) it will be excluded. If no rule matches the row will be excluded. Inclusion and exclusion may be inverted, see the options below.
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 either TRUE or FALSE.
If no rule matches, the outcome is treated as if it was FALSE.
Columns are given by their names surrounded by $, 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.
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.
Some example rules (each should be in one row):
// This is a comment $Col0$ > 0 => TRUEWhen the values in Col0 are greater than 0, we select the row (if no previous rule matched with FALSE outcome).
$Col0$ = "Active" AND $Col1$ <= 5 => TRUEYou can combine conditions.
$Col0$ LIKE "Market Street*" AND
($Col1$ IN ("married", "divorced")
OR $Col2$ > 40) => FALSE
With parentheses you can combine multiple conditions.
$Col0$ MATCHES $${SFlowVar0}$$ OR $$ROWINDEX$$ < $${IFlowVar1}$$ =>
FALSE
The flow variables, table constants can also appear in conditions.
The following comparisons result true (other values are neither less, nor greater or equal to missing and NaN values):
- ? =,<=,>= ?
- NaN =,<=,>= NaN
Options
Popular Successors
Excel Writer (XLS)2 %Database Writer2 %Row Splitter (deprecated)2 %Joiner2 %- Rule-based Row Filter2 %
- Strings to Document2 %
- Table Difference Checker2 %
Cell Splitter1 %- Joiner1 %
- Row Sampler1 %
- Empty Table Switch1 %
- Collection to String1 %
- Cluster Assigner1 %
Cell Replacer1 %Column Appender1 %- Rule Engine (Dictionary)1 %
- Category to Class1 %
- Tag Cloud (JavaScript) (legacy)1 %
String to Date&Time1 %Table Row To Variable Loop Start< 1 %- Group Loop Start< 1 %
- Binner (Dictionary)< 1 %
- Column Name Extractor< 1 %
- Column Name Replacer< 1 %
- Filter Apply Row Splitter< 1 %
Row Filter (deprecated)< 1 %- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Missing Value< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Interactive Table (legacy)< 1 %
- Math Formula< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %- Columns to JSON< 1 %
- MarvinView< 1 %
- CSV Writer< 1 %
- Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Perl Scripting< 1 %
- Concatenate< 1 %
- Cell Splitter< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
Constant Value Column< 1 %- Duplicate Row Filter< 1 %
- Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- GroupBy< 1 %
- Table Partitioner< 1 %
- String Splitter (Regex)< 1 %
Column Rename< 1 %- Sorter< 1 %
- String Manipulation< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Statistics< 1 %
- End IF< 1 %
Color Manager< 1 %- Excel Writer< 1 %
- TF< 1 %
- Table View (JavaScript) (legacy)< 1 %
Date&Time-based Row Filter< 1 %Loop End< 1 %- Pivot< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- OpenBabel< 1 %
Bag of Words Creator< 1 %Table Writer< 1 %- Fuzzy Rule Learner< 1 %
- Column Comparator< 1 %
Number To String< 1 %- Column Aggregator< 1 %
- Cross Joiner< 1 %
- Table to Spark< 1 %
DB Writer< 1 %XLS Writer< 1 %- Java Snippet Row Filter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Nominal Row Filter Widget< 1 %
- HTTP Retriever< 1 %
- Substructure Matcher< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %CSV Writer< 1 %Database Update< 1 %- Java Snippet< 1 %
- RProp MLP Learner< 1 %
Concatenate (Optional in)< 1 %- Equal Size Sampling< 1 %
- Value Counter< 1 %
- IF Switch< 1 %
- ROC Curve (legacy)< 1 %
SDF Writer< 1 %- Dictionary Filter< 1 %
- Column to XML< 1 %
- URL Domain Extractor< 1 %
IF Switch (Flow Variable Value)< 1 %Loop End (3 ports)< 1 %- Plate Row Converter< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- Table Row to Variable< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
Recursive Loop End< 1 %Recursive Loop Start< 1 %- Naive Bayes Learner< 1 %
- Decision Tree Learner< 1 %
- Decision Tree Predictor< 1 %
- Linear Regression Learner< 1 %
Logistic Regression Learner< 1 %Scorer< 1 %- Case Converter< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Merger< 1 %
- One to Many< 1 %
- Correlation Filter< 1 %
- Reference Table Validator< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- RowID< 1 %
- String Replacer< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Data Explorer< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Box Plot (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Molecule Type Cast< 1 %
- Parallel Chunk End< 1 %
DB Insert< 1 %- Counter Generation< 1 %
- Random Number Assigner< 1 %
- Similarity Search< 1 %
- Math Formula (Variable)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- OSM Map View< 1 %
Excel Writer (XLS)< 1 %- Java IF (Table)< 1 %
- String Matcher< 1 %
- Stop Word Filter< 1 %
- Tag Filter< 1 %
Dictionary tagger< 1 %- Bag Of Words Creator< 1 %
Strings To Document< 1 %- Google Sheets Updater< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- JSON Path< 1 %
- R Snippet< 1 %
Date&Time Difference< 1 %Extract Date&Time Fields< 1 %String to Date/Time< 1 %- XML Row Combine and Write< 1 %
- RDKit Molecule Substructure Filter< 1 %
Views
- This node has no views
Workflows
07_Log_Parser_and_Usage_Reporting_on_KNIME_ServerKNIME Hub- 07_Log_Parser_and_Usage_Reporting_on_KNIME_ServerKNIME Hub
- Data_selectionKNIME Hub
- Data_selection_for_ForumKNIME Forum
- Dynamic Row filtering using Rules TableKNIME Hub
- Show all 21 workflows
Links
- Concatenate Bug?by armingrudd on 2020-02-16forum.knime.com/p/81689
- Change Request - Make it possible to evaluate multiple columns in Reference Row Filter & Splitterby armingrudd on 2020-02-20forum.knime.com/p/82137
- Row filtering using multiple tablesby armingrudd on 2019-08-05forum.knime.com/p/67162
- Filter table output based on another table’s dateby armingrudd on 2020-04-14forum.knime.com/p/87400
- search a list of word on datasetby izaychik63 on 2020-01-21forum.knime.com/p/79273
- Show all 12 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.