This node uses a well-defined numeric range to split the input data into two parts. While the first output port contains the data that matches the criteria, the second contains the data that does not comply with the settings. Within the dialog the user can select one numeric column and optionally specify a lower and upper bound on it to split the data that matches/does not match the criteria.
Options
Popular Predecessors
- GroupBy9 %
Table Row to Variable4 %Row Filter (deprecated)4 %- Numeric Row Splitter3 %
- Joiner3 %
- String to Number3 %
Excel Reader (XLS)3 %- String Manipulation2 %
Row Splitter (deprecated)2 %- Nominal Value Row Splitter2 %
Table Reader2 %- Math Formula2 %
- Java Snippet (simple)2 %
- Nominal Value Row Filter1 %
- Value Counter1 %
- Normalizer1 %
Number To String1 %- Date&Time Difference1 %
- Excel Reader1 %
- CSV Reader< 1 %
- Sorter< 1 %
- Duplicate Row Filter< 1 %
- Numeric Binner< 1 %
- Rule-based Row Filter< 1 %
Cell Splitter< 1 %- Column Filter< 1 %
- Rank< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %- Column Aggregator< 1 %
- Domain Calculator< 1 %
- String Similarity< 1 %
Concatenate (Optional in)< 1 %- Column Resorter< 1 %
- Rule Engine< 1 %
- Date&Time-based Row Filter< 1 %
Recursive Loop Start< 1 %File Reader< 1 %- Double Input (legacy)< 1 %
- SDF Reader< 1 %
- Table Row to Variable< 1 %
- Generic JavaScript View (JavaScript)< 1 %
Table Column to Variable< 1 %Counting Loop Start< 1 %- Table Transposer< 1 %
Database Reader< 1 %- Concatenate< 1 %
Linear Correlation< 1 %- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Partitioning< 1 %
- Math Formula (Variable)< 1 %
- Fingerprint Similarity< 1 %
- Loop End< 1 %
- Column Merger< 1 %
- Linear Correlation< 1 %
Interval Loop Start< 1 %- Chunk Loop Start< 1 %
- Date Field Extractor (legacy)< 1 %
- SDF Stripper< 1 %
- Column Expressions< 1 %
- Split Collection Column< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
- Java Edit Variable< 1 %
- Create Bit Vector< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Missing Value< 1 %
Column Rename< 1 %- Ungroup< 1 %
- Numeric Outliers< 1 %
- Color Manager< 1 %
- Parallel Chunk End< 1 %
- Math Formula (Multi Column)< 1 %
- Molecular Properties< 1 %
- RDKit Substructure Filter< 1 %
- One to Many< 1 %
- Constant Value Column Filter< 1 %
- Counter Generation< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Integer Widget< 1 %
- String to Date&Time< 1 %
XLS Formatter (apply)< 1 %- Table Row to Variable Loop Start< 1 %
- Double Widget< 1 %
- Python Script (legacy)< 1 %
- RDKit R-Group Decomposition< 1 %
- Data Explorer< 1 %
- Fingerprint Similarity< 1 %
- Fingerprint Similarity< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Group Loop Start< 1 %
- Column Combiner< 1 %
String To Number< 1 %- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- Filter Apply Row Splitter< 1 %
- Pivot< 1 %
- RowID< 1 %
- Column Splitter< 1 %
- Rule-based Row Splitter< 1 %
- One-way ANOVA< 1 %
- Statistics< 1 %
- Time Difference (legacy)< 1 %
- Lipinski's Rule-of-Five< 1 %
- RDKit Descriptor Calculation< 1 %
Table Row to Variable< 1 %- Table Creator< 1 %
- Regression Predictor< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- String Replacer< 1 %
- DB Reader< 1 %
- Table Column to Variable< 1 %
- File Reader< 1 %
- Table Manipulator< 1 %
- Numeric Scorer< 1 %
- Date&Time Part Extractor< 1 %
- Shapiro-Wilk Test< 1 %
- File Reader (Complex Format)< 1 %
- Generic Loop Start< 1 %
- Variable Creator< 1 %
- Molecule Properties< 1 %
Cell Replacer< 1 %- Network Analyzer< 1 %
Python Script (1⇒1)< 1 %Table Column to Variable< 1 %Generic Loop Start< 1 %Numeric Scorer< 1 %- Shuffle< 1 %
- End IF< 1 %
- Box Plot (legacy)< 1 %
- Variable Expressions< 1 %
- DB Query Reader< 1 %
Table Row To Variable Loop Start< 1 %- ARFF Reader< 1 %
List Files< 1 %- Column List Loop Start< 1 %
Variable Loop End< 1 %- X-Aggregator< 1 %
- k-Means< 1 %
- Distance Matrix Pair Extractor< 1 %
- Unpivot< 1 %
Merge Variables< 1 %- R Source (Table)< 1 %
Database Connection Table Reader< 1 %Loop End (2 ports)< 1 %Regression Predictor< 1 %- Reference Column Splitter< 1 %
String To Number (PMML)< 1 %- Number Filter< 1 %
- Column Filter Configuration< 1 %
- Integer Configuration< 1 %
- HTML Parser< 1 %
- Merge Variables< 1 %
- Enrichment Plotter (legacy)< 1 %
- CDK to Molecule< 1 %
- Substructure Matcher< 1 %
- X-Partitioner< 1 %
- PNN Predictor< 1 %
- Column Comparator< 1 %
- Constant Value Column< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Java Edit Variable (simple)< 1 %
- String Matcher< 1 %
- Parameter Optimization Loop Start< 1 %
- Molecule to CDK< 1 %
- Speedy SMILES Chiral Centre Count< 1 %
- Speedy SMILES Heavy Atom Count (HAC)< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Create Collection Column< 1 %
Column Appender< 1 %- Rank Correlation< 1 %
Parquet Reader< 1 %- Random Number Assigner< 1 %
- Bag Of Words Creator< 1 %
- Slider Input (legacy)< 1 %
- Create Date&Time Range< 1 %
- Column Appender< 1 %
- Twitter Search< 1 %
- RDKit From Molecule< 1 %
- MolSearch< 1 %
- Catch Errors (Data Ports)< 1 %
CSV Reader< 1 %Database Writer< 1 %Recursive Loop Start (2 ports)< 1 %Scorer< 1 %- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Category to Number< 1 %
- Double to Integer< 1 %
- Number Rounder< 1 %
- Paired t-test< 1 %
- Vocabulary Extractor (legacy)< 1 %
- Snowball Stemmer< 1 %
Strings To Document< 1 %- Tags to String< 1 %
- Integer Input (legacy)< 1 %
- R Predictor< 1 %
- R Snippet< 1 %
Extract Date&Time Fields< 1 %- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Fingerprint< 1 %
- RDKit To Molecule< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Molecule Properties< 1 %
- Speedy SMILES Charge Count< 1 %
IF Switch (Flow Variable Value)< 1 %- Fragments to MMPs< 1 %
- List Folders< 1 %
- Join Layout< 1 %
- Normalize Plates (Z-Score)< 1 %
- Outlier Removal< 1 %
- CV< 1 %
- pKa< 1 %
- Automated Matched Pairs< 1 %
- URL to File Path< 1 %
Table Column to Variable< 1 %CSV Writer< 1 %- Fixed Width File Reader< 1 %
Variable Condition Loop End< 1 %- Decision Tree Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %Tree Ensemble Predictor< 1 %- Many to One< 1 %
- Table Validator< 1 %
Double To Int< 1 %- Reference Column Filter< 1 %
- Row Splitter (Labs)< 1 %
- Low Variance Filter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Numeric Binner (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %- String to Number (PMML)< 1 %
- Row Sampling< 1 %
- Rule Engine Variable< 1 %
- Parallel Chunk Start< 1 %
- One Row to Many< 1 %
- k-Medoids< 1 %
- Similarity Search< 1 %
- OpenBabel< 1 %
Read XLS Sheet Names< 1 %Excel Reader (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- IDF< 1 %
- Category to Class< 1 %
- NGram Creator< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Nominal Row Filter Configuration< 1 %
- Double Configuration< 1 %
- Integer Slider Configuration< 1 %
- Column Filter (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Image to DataRow< 1 %
Python Script (1⇒1)< 1 %- GET Request< 1 %
- Date&Time to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- Time Generator (legacy)< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
XML Reader< 1 %- Row Splitter (col+)< 1 %
- SMARTS Query< 1 %
- RDKit Substructure Counter< 1 %
- Feature Table To List< 1 %
- ARIMA Predictor< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Loop End (Column Append)< 1 %
Table Row To Variable Loop Start< 1 %- Edit Nominal Domain (Dictionary)< 1 %
- Extract Missing Value Cause< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Tika Language Detector< 1 %
- Punctuation Erasure< 1 %
- Strings to Document< 1 %
- Files/Folders Meta Info< 1 %
- Slider Widget< 1 %
- JSON to Table< 1 %
- POST Request< 1 %
- Logger Option< 1 %
- Legacy Date&Time to Date&Time< 1 %
- XLogP< 1 %
RDKit Functional Group Filter< 1 %- RDKit Optimize Geometry< 1 %
Views
- This node has no views
Workflows
02-download_and_analyze_raw_fileKNIME Hub- all paths in networkKNIME Forum
- Bioactive compound libraryKNIME Hub
- C24_Fraudulent Email Address DetectionKNIME Hub
- Case 3 DC SelectionKNIME Hub
- Show all 57 workflows
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.