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 Predecessors
- Rule-based Row Filter7 %
Row Filter (deprecated)5 %- Table Creator5 %
- String Manipulation3 %
Database Reader2 %- Excel Reader2 %
Number To String2 %- GroupBy2 %
- Rule-based Row Filter (Dictionary)1 %
- CSV Writer1 %
File Reader1 %XLS Reader1 %Excel Reader (XLS)1 %Cell Splitter1 %Variable to Table Row1 %- String Replacer1 %
- Duplicate Row Filter< 1 %
Excel Reader (XLS)< 1 %- Joiner< 1 %
- Math Formula< 1 %
- Table Manipulator< 1 %
Table Row To Variable Loop Start< 1 %String To Number< 1 %- Constant Value Column< 1 %
- Multiple Selections (legacy)< 1 %
Variable to Table Row< 1 %- Column Rename (Regex)< 1 %
- Missing Value Column Filter< 1 %
- Rule Engine (Dictionary)< 1 %
Extract Date&Time Fields< 1 %- String to Number< 1 %
- Column Filter (PMML)< 1 %
- Table Editor (JavaScript)< 1 %
- String to Date&Time< 1 %
- CSV Reader< 1 %
Concatenate (Optional in)< 1 %Joiner< 1 %- Table Transposer< 1 %
- List Box Input (legacy)< 1 %
- Expand Well Position< 1 %
- Cell Splitter< 1 %
Database Connection Table Reader< 1 %Column Rename< 1 %- Rule Engine< 1 %
- Domain Calculator< 1 %
- DB Reader< 1 %
- Parquet Reader< 1 %
- Case Converter< 1 %
- Create Collection Column< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
Recursive Loop Start< 1 %Cell Replacer< 1 %- Column Filter< 1 %
- Partitioning< 1 %
- Pivot< 1 %
- RowID< 1 %
- IF Switch< 1 %
- Column Expressions (legacy)< 1 %
- Date&Time Difference< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Number to String< 1 %
- DB Query Reader< 1 %
- Total Count< 1 %
- Molecule Properties< 1 %
- Table Row to Variable Loop Start< 1 %
- File Reader (Complex Format)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Recursive Loop Start< 1 %
- Loop End< 1 %
- Column Renamer< 1 %
CSV Reader< 1 %Loop End (2 ports)< 1 %- Chunk Loop Start< 1 %
- Decision Tree Predictor< 1 %
- Concatenate< 1 %
- Column Combiner< 1 %
- Column Resorter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Missing Value< 1 %
- Sorter< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- Rule-based Row Splitter< 1 %
- Decision Tree to Ruleset< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- End IF< 1 %
- SDF Reader< 1 %
- Empty Table Creator< 1 %
- Strings to Document< 1 %
- Create Date&Time Range< 1 %
- Date&Time-based Row Filter< 1 %
- Group Loop Start< 1 %
- Extract Missing Value Cause< 1 %
- Row Filter (Labs)< 1 %
- String Manipulation (Multi Column)< 1 %
- Ruleset Editor< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Table Reader< 1 %
- Unpivot< 1 %
- Stop Word Filter< 1 %
- Path to String< 1 %
Spacy Vectorizer< 1 %- Date&Time Part Extractor< 1 %
- Boolean Configuration< 1 %
- Date&Time Shift< 1 %
- Cache< 1 %
Table Reader< 1 %Column Appender< 1 %- Lag Column< 1 %
- Value Counter< 1 %
- Statistics< 1 %
- Document Data Extractor< 1 %
- Rank< 1 %
- List Files/Folders< 1 %
List Files< 1 %- Nominal Value Row Splitter< 1 %
CASE Switch Data (Start)< 1 %- Data Generator< 1 %
Excel Reader (XLS)< 1 %- RegEx Filter< 1 %
- Numeric Row Splitter< 1 %
- Color Manager< 1 %
- Tika Language Detector< 1 %
Table Column to Variable< 1 %- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- String to Term< 1 %
- Tag Cloud (JavaScript)< 1 %
- Java Snippet< 1 %
Generic Loop Start< 1 %- Binner (Dictionary)< 1 %
- Column Merger< 1 %
- String Splitter (Regex)< 1 %
Strings To Document< 1 %- Google Sheets Reader< 1 %
- Column Filter (legacy)< 1 %
- R Snippet< 1 %
- String to Date/Time (legacy)< 1 %
Interval Loop Start< 1 %Scorer< 1 %- Correlation Filter< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- Row Sampling< 1 %
- Top k Row Filter< 1 %
- Numeric Outliers< 1 %
- TF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Dictionary Filter< 1 %
- Line Plot (JavaScript)< 1 %
- Container Input (Table)< 1 %
- JSON to Table< 1 %
- Table Row to Variable< 1 %
- List Box Widget< 1 %
- MarvinSketch< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %Database Looping< 1 %- Loop End (Column Append)< 1 %
Recursive Loop Start (2 ports)< 1 %- Association Rule Learner< 1 %
Random Forest Predictor< 1 %- Case Converter< 1 %
- Column Aggregator< 1 %
- Reference Row Splitter< 1 %
- Missing Value (Apply)< 1 %
- Set Operator< 1 %
- Extract Table Spec< 1 %
Read XLS Sheet Names< 1 %- Java Snippet Row Filter< 1 %
- Snowball Stemmer< 1 %
- Sentence Extractor< 1 %
- Term to String< 1 %
- Boolean Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- XPath< 1 %
- OPSIN< 1 %
- RDKit Fingerprint< 1 %
- Canonical SMILES< 1 %
- Collection to String< 1 %
- Shapefile Polygon Reader< 1 %
- PIA Analysis< 1 %
- Fix Column Names< 1 %
- URI to String< 1 %
Simple File Reader< 1 %Line Reader< 1 %- Fuzzy Rule Learner< 1 %
- Tree Ensemble Predictor< 1 %
- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Create Table Structure< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Column Splitter< 1 %
- Ruleset to Table< 1 %
- Data Explorer< 1 %
- One-way ANOVA< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Parallel Chunk End< 1 %
- Math Formula (Multi Column)< 1 %
- Geo-Coordinate Row Filter< 1 %
- Java Snippet (simple)< 1 %
- Vocabulary Extractor (legacy)< 1 %
- NGram Creator< 1 %
- N Chars Filter< 1 %
- Tag Filter< 1 %
- Dictionary Tagger< 1 %
- Stanford Tagger< 1 %
Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
- Tags to String< 1 %
- Table View (JavaScript)< 1 %
- Multiple Selection Widget< 1 %
- Python Source (legacy)< 1 %
- Date&Time to String< 1 %
- Time to String (legacy)< 1 %
Location Extractor< 1 %Table Row to Variable< 1 %- Line Reader< 1 %
- Variable Loop End< 1 %
- Linear Regression Learner< 1 %
- Add Empty Rows< 1 %
- Linear Correlation< 1 %
- Table Validator< 1 %
- String Manipulation (Variable)< 1 %
- Counter Generation< 1 %
- Wildcard Tagger< 1 %
- Path to URI< 1 %
Transfer Files< 1 %- GeoJSON reader< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 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
- Ensembl API ModulesKNIME Hub
- Fast Dynamic RulesKNIME Hub
- Filtering Cells containing StringKNIME Hub
- Show all 17 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.