The RowFilter node has been adapted to allow for multiple column selection to perform the attribute matching (include and exclude). It is possible to match based on a single column match (only one must return true) or every column match (all must return true).
Example usage: String column with numbers, int column and a double column. Using the pattern 1 will return matches for "1" in the int column and the String column however will not match the double column. To match the value '1' on a double column the pattern needs to be '1.0'. If you want the same match to work accross these three columns then you can use the regex: '(1|1\.0)' (no quotes) which makes the '.0' optional.
Range filtering on mixed column types is not recommended. It is best to use all Int columns, all Double columns or all String columns etc. Although filtering on Strings will likely give unexpected results.
Options
Popular Successors
- String Manipulation7 %
Joiner7 %- Value Counter5 %
- Excel Writer4 %
Concatenate (Optional in)3 %Row Filter (deprecated)3 %- Reference Row Splitter3 %
- Ungroup3 %
- Row Splitter (Labs)3 %
- GroupBy3 %
- Rule Engine3 %
- Reference Row Filter2 %
- Joiner2 %
Table Writer2 %- Concatenate2 %
- Duplicate Row Filter2 %
- Column Filter2 %
Row Splitter (deprecated)2 %- Row Sampling2 %
- Table Transposer2 %
- Row Splitter (col+)2 %
- Constant Value Column2 %
- Rule-based Row Splitter2 %
CSV Writer1 %Regression Predictor1 %- Column Comparator1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
Cell Replacer< 1 %Column Appender< 1 %- Missing Value Column Filter< 1 %
- Pivot< 1 %
- String Replacer< 1 %
- IF Switch< 1 %
- Box Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- SDF Writer< 1 %
- Similarity Search< 1 %
- Canonical SMILES< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- 2D/3D Scatterplot< 1 %
Element Selector< 1 %Table Row to Variable< 1 %Database Writer< 1 %- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- k-Means< 1 %
K Nearest Neighbor< 1 %PCA< 1 %- Polynomial Regression Learner< 1 %
Scorer< 1 %Numeric Scorer< 1 %- SMOTE< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Column Resorter< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
Column Rename< 1 %- Numeric Row Splitter< 1 %
- Sorter< 1 %
- Cache< 1 %
- Interactive Histogram (legacy)< 1 %
- Column Expressions< 1 %
- Generic Web Service Client< 1 %
Excel Writer (XLS)< 1 %- Dictionary Replacer< 1 %
- Value Filter (legacy)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Splitter (uncropped)< 1 %
- R View (Table)< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
Table to HTML String< 1 %- RDKit Generate Coords< 1 %
- RDKit Fingerprint< 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.