Splits the rows based on the selected value of a nominal attribute. A nominal column can be selected and one or more nominal values of this attribute. Rows which have this nominal value in the selected column are included in the output data in the first table, the rest in the second.
In order for a nominal column to appear in the node dialog, its domain (the set of values that appear in the column) must be calculated. For columns with few values (less than 60) this is done automatically. To ensure the domain is properly set, use the Domain Calculator node or the Edit Nominal Domain node.
Options
Popular Successors
- GroupBy10 %
- Joiner7 %
- Concatenate7 %
- Nominal Value Row Splitter5 %
- Column Filter3 %
- Excel Writer3 %
- Rule Engine2 %
- Rule-based Row Splitter2 %
- Nominal Value Row Filter2 %
Row Filter (deprecated)2 %- Constant Value Column2 %
Row Splitter (deprecated)2 %- Pivot1 %
- String Manipulation1 %
- Reference Row Filter< 1 %
- Math Formula< 1 %
- Rule-based Row Filter< 1 %
- Table Row to Variable Loop Start< 1 %
Concatenate (Optional in)< 1 %String To Number< 1 %Column Appender< 1 %Column Rename< 1 %- Row Sampler< 1 %
- Group Loop Start< 1 %
- Table View< 1 %
Table Writer< 1 %- Duplicate Row Filter< 1 %
- Numeric Row Splitter< 1 %
- Top k Row Filter< 1 %
- Box Plot (legacy)< 1 %
- Column Expressions (legacy)< 1 %
- Normalize Plates (POC)< 1 %
- X-Partitioner< 1 %
- Regression Predictor< 1 %
- Column Resorter< 1 %
- Reference Row Splitter< 1 %
- Single sample t-test< 1 %
- CSV Writer< 1 %
- Random Forest Learner< 1 %
- Sorter< 1 %
- String to Number< 1 %
- Statistics< 1 %
Python Script (1⇒1)< 1 %- R Plot< 1 %
- Table Row to Variable< 1 %
- Table Writer< 1 %
- Bootstrap Sampling< 1 %
- Table Partitioner< 1 %
String Replace (Dictionary)< 1 %Excel Sheet Appender (XLS)< 1 %- Interactive Value Filter Widget< 1 %
- Category to Number< 1 %
- One to Many< 1 %
- Missing Value< 1 %
- Table Difference Finder< 1 %
- Google Sheets Updater< 1 %
- Geo Distances< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Gradient Boosted Trees Predictor< 1 %
- Auto-Binner< 1 %
- String Splitter (Regex)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Conditional Box Plot (legacy)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Tag Filter< 1 %
- Tile View (JavaScript) (legacy)< 1 %
- Moving Aggregator< 1 %
Table Row To Variable Loop Start< 1 %CSV Writer< 1 %- k-Means< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
- Linear Correlation< 1 %
- Normalizer (Apply)< 1 %
- Number Rounder< 1 %
- Shuffle< 1 %
- Rule Engine (Dictionary)< 1 %
- Cache< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
Excel Sheet Appender (XLS)< 1 %- Snowball Stemmer< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
Date&Time Difference< 1 %String to Date&Time< 1 %- Loop End< 1 %
- Chunk Loop Start< 1 %
- Hierarchical Clustering< 1 %
- Decision Tree Learner< 1 %
- Linear Regression Learner< 1 %
- SMOTE< 1 %
- Numeric Binner< 1 %
Cell Replacer< 1 %- Cell Splitter< 1 %
- Cell Splitter By Position< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Cross Joiner< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Filter Apply Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Row Splitter (Labs)< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- Normalizer< 1 %
- Rank< 1 %
- RowID< 1 %
Column Splitter< 1 %- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Value Lookup< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Shapiro-Wilk Test< 1 %
- Independent groups t-test< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Bar Chart< 1 %
- Histogram< 1 %
- SDF Writer< 1 %
- DB Delete (Table)< 1 %
- DB Writer< 1 %
- Counter Generation< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Tika Parser URL Input< 1 %
- Strings to Document< 1 %
- Google Sheets Writer< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Python Script (legacy)< 1 %
- R View (Table)< 1 %
Date&Time to String< 1 %- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
Date&Time Shift< 1 %- String to Date/Time (legacy)< 1 %
- RDKit Interactive Table< 1 %
- RDKit Fingerprint< 1 %
Regex Extractor< 1 %- Regex Extractor< 1 %
- Create Collection Column< 1 %
- Table Column to Variable< 1 %
Naive Bayes Learner< 1 %- Logistic Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
Cell Splitter< 1 %- String to Number (PMML)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Random Number Assigner< 1 %
Excel Writer (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Number Formatter< 1 %
Database Table Creator< 1 %Counting Loop Start< 1 %- Naive Bayes Learner< 1 %
PCA< 1 %- Lag Column< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- One-way ANOVA< 1 %
- DB Insert< 1 %
- Similarity Search< 1 %
- Bar Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Java Snippet Row Splitter< 1 %
- GET Request< 1 %
- String Similarity< 1 %
- 2D/3D Scatterplot< 1 %
- String to URI< 1 %
- URL to File Path< 1 %
- Inject Variables (Data)< 1 %
Variable to Table Row< 1 %Database Looping< 1 %- Recursive Loop Start< 1 %
- Fuzzy c-Means< 1 %
K Nearest Neighbor< 1 %- Logistic Regression Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %Random Forest Predictor< 1 %- Random Forest Predictor< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Number to Category (Apply)< 1 %
- Correlation Filter< 1 %
- Constant Value Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Reference Column Resorter< 1 %
- Crosstab< 1 %
Color Appender< 1 %Excel Reader (XLS)< 1 %- String to Path< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- String to JSON< 1 %
- CLAHE< 1 %
- Python View (legacy)< 1 %
Extract Duration Fields< 1 %- Extract Time Window (legacy)< 1 %
- Row Splitter (col+)< 1 %
Table Extractor< 1 %- Molecule Properties< 1 %
- Join Layout< 1 %
- Enrichment Analyzer< 1 %
- Binning Calculate< 1 %
- Normalize Plates (B-Score)< 1 %
- Normalize Plates (NPI)< 1 %
- Normalize Plates (Z-Score)< 1 %
- Outlier Removal< 1 %
- Z-Primes (PC x NC)< 1 %
- Plate Heatmap Viewer< 1 %
- R Snippet< 1 %
ChemSpider (deprecated)< 1 %- ARIMA Visualization< 1 %
- Audio Viewer (legacy)< 1 %
- Copy/Move Files (legacy)< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Table Row to Variable< 1 %Image Writer (Table Column)< 1 %Database Writer< 1 %Parameterized Database Query< 1 %- Loop End (Column Append)< 1 %
- Column List Loop Start< 1 %
Recursive Loop End< 1 %Recursive Loop Start (2 ports)< 1 %- Naive Bayes Predictor< 1 %
- PNN Learner (DDA)< 1 %
- PNN Predictor< 1 %
- Decision Tree to Image< 1 %
- Decision Tree Predictor< 1 %
- K Nearest Neighbor< 1 %
- RProp MLP Learner< 1 %
- Numeric Scorer< 1 %
- SVM Learner< 1 %
Gradient Boosted Trees Learner< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Tree Ensemble Learner< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Case Converter< 1 %
Number To String< 1 %- Column Name Replacer< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Table Validator (Reference)< 1 %
- Edit Nominal Domain< 1 %
- Double to Integer< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Key-Collection HiLite Translator< 1 %
- Nominal Probability Distribution Creator< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- Renderer to Image< 1 %
- Kolmogorov-Smirnov Test< 1 %
- Kruskal-Wallis Test< 1 %
- Paired t-test< 1 %
CASE Switch Variable (Start)< 1 %CASE Switch Data (End)< 1 %- IF Switch< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- PMML Transformation Apply< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- Gaussian Distributed Assigner< 1 %
- One Rule Inserter< 1 %
- Random Label Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- Random Number Assigner (Apache)< 1 %
- Distance Matrix Calculate< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- 2D Density Plot (Plotly)< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Line Plot (Plotly)< 1 %
- OpenBabel< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- LIBSVMPredictor< 1 %
- Tableau Writer< 1 %
Tableau Writer (TDE)< 1 %- Word2Vec Learner (legacy)< 1 %
- Frequency Filter< 1 %
- TF< 1 %
- Keygraph Keyword Extractor< 1 %
- String Matcher< 1 %
- Diacritic Remover< 1 %
- RegEx Filter< 1 %
- Tag Cloud< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Weka Predictor (3.7)< 1 %
- Google Sheets Appender< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Decision Tree View (JavaScript) (legacy)< 1 %
- ROC Curve (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- JSON Row Combiner< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
- Columns to JSON< 1 %
- Node Name Filter< 1 %
- Object Inserter< 1 %
- Multiobjective Score Computation< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
- Python Predictor (legacy)< 1 %
Python Script (2⇒1)< 1 %- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %Modify Time< 1 %- Window Loop Start< 1 %
- Date Field Extractor (legacy)< 1 %
XGBoost Tree Ensemble Learner< 1 %- XGBoost Predictor< 1 %
- String to XML< 1 %
Binary Scorer< 1 %- Molecule to CDK< 1 %
- Molecular Properties< 1 %
- 3D Viewer< 1 %
- RDKit Canon SMILES< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Information Gain Calculator< 1 %
- Text Classifier Learner< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Hash Calculator< 1 %
- HTML Parser< 1 %
Views
- This node has no views
Workflows
01_AK_generate_html_from_picturesKNIME Forum- 01_Training Isolation Forest for Fraud DetectionKNIME Hub
- 02 Data app - 2 ViewsKNIME Hub
- 02 Data app - 2 ViewsKNIME Hub
- 02 Data app - 2 ViewsKNIME Hub
- Show all 154 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.