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
- GroupBy5 %
Table Row to Variable5 %Excel Reader (XLS)4 %Table Reader3 %- Java Snippet (simple)2 %
Row Filter (deprecated)2 %- Value Counter2 %
- Normalizer2 %
Number To String1 %- Numeric Binner1 %
Cell Splitter< 1 %XLS Reader< 1 %Excel Reader (XLS)< 1 %- Column Aggregator< 1 %
- Domain Calculator< 1 %
Concatenate (Optional in)< 1 %Recursive Loop Start< 1 %File Reader< 1 %- Numeric Row Splitter< 1 %
- Rule-based Row Filter< 1 %
- Double Input (legacy)< 1 %
- SDF Reader< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
Table Column to Variable< 1 %Counting Loop Start< 1 %- RowID< 1 %
- Table Transposer< 1 %
- Duplicate Row Filter< 1 %
- Excel Reader< 1 %
Database Reader< 1 %Linear Correlation< 1 %- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Table Partitioner< 1 %
- Fingerprint Similarity< 1 %
- String to Number< 1 %
- Loop End< 1 %
- Column Merger< 1 %
- Linear Correlation< 1 %
Interval Loop Start< 1 %- Chunk Loop Start< 1 %
- Nominal Value Row Splitter< 1 %
- Date Field Extractor (legacy)< 1 %
- SDF Stripper< 1 %
- Split Collection Column< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
- Java Edit Variable< 1 %
- Concatenate< 1 %
- Create Bit Vector< 1 %
- HiLite Row Splitter< 1 %
Joiner< 1 %Column Rename< 1 %- Ungroup< 1 %
- Rule Engine< 1 %
- Numeric Outliers< 1 %
- Color Manager< 1 %
- Parallel Chunk End< 1 %
- Math Formula< 1 %
- Math Formula (Variable)< 1 %
Date&Time Difference< 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 %
- Joiner< 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 Name Replacer< 1 %
- Column Resorter< 1 %
- Cross Joiner< 1 %
- Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rank< 1 %
- Sorter< 1 %
Column Splitter< 1 %- String Manipulation< 1 %
- Rule-based Row Splitter< 1 %
- One-way ANOVA< 1 %
- Statistics< 1 %
- Math Formula (Multi Column)< 1 %
- Date&Time-based Row Filter< 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 %
- Similarity Search< 1 %
- Column Expressions (legacy)< 1 %
- String Similarity< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
- CSV Reader< 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 (legacy)< 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 (deprecated)< 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 %
- Columns to Collection< 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 (legacy)< 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 %- Constant Value Row Appender< 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 Sampler< 1 %
- Rule Engine Variable< 1 %
- Parallel Chunk Start< 1 %
- One Row to Many< 1 %
- k-Medoids< 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) (legacy)< 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- AI_Fraud_DetectionKNIME Hub
- AI_Fraud_DetectionKNIME Hub
- all paths in networkKNIME Forum
- Bioactive compound libraryKNIME Hub
- Show all 65 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.