The node can be configured to handle either of the definitions of missing or both.
For example if you have a scenario where you have RowIds but no columns if you want to return a completely empty table then ensure the 'Remove row where no columns are present' is selected. If you only wont to manipulate the table when no columns are present (for example when working through a loop giving different input) then ensure 'Remove row where no columns are present' is checked and 'Remove entirely Missing Cell rows' is not checked. If both are selected you will also lose rows that consist of only missing cells.
Example Input:
| RowID | Col1 | Col2 |
|---|---|---|
| Row1 | A | B |
| Row2 | C | |
| Row3 |
Output when 'Remove entirely Missing Cell rows' is enabled:
| RowID | Col1 | Col2 |
|---|---|---|
| Row1 | A | B |
| Row2 | C |
If unchecked no change will be seen.
Second example input:
| RowID |
|---|
| Row1 |
| Row2 |
| Row3 |
Expected output if 'Remove row where no columns are present' is checked (a completely empty table):
| RowID |
|---|
If unchecked the table will remain unchanged.
Options
Popular Successors
Row Filter (deprecated)3 %- Rule-based Row Filter3 %
- Cell Splitter2 %
- Joiner2 %
- Rule-based Row Splitter2 %
Joiner2 %- Empty Table Switch2 %
- Duplicate Row Filter2 %
- Reference Row Filter2 %
- Table Transposer2 %
- Loop End (Column Append)1 %
- Column Name Extractor1 %
Column Rename1 %- Number Rounder1 %
- String Manipulation1 %
- Rule Engine1 %
- Date&Time to String1 %
- Java Snippet1 %
- Column Resorter1 %
- Constant Value Column1 %
- Reference Column Filter1 %
- Missing Value Column Filter1 %
- GroupBy1 %
- Reference Column Resorter1 %
- Extract Table Dimension1 %
- Substructure Matcher< 1 %
- Catch Errors (Data Ports)< 1 %
- CSV Writer< 1 %
- Loop End< 1 %
- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
- Concatenate< 1 %
Cell Splitter< 1 %- String to Number< 1 %
Column Appender< 1 %- Column Appender< 1 %
- Column Merger< 1 %
- Cross Joiner< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Missing Value< 1 %
- RowID< 1 %
- Sorter< 1 %
- String Manipulation (Multi Column)< 1 %
- Statistics< 1 %
- End IF< 1 %
- Molecule Type Cast< 1 %
- DB Delete (Table)< 1 %
- DB Writer< 1 %
- Counter Generation< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %- Excel Writer< 1 %
- Strings to Document< 1 %
- Line Plot (JavaScript)< 1 %
- String to Date&Time< 1 %
- RDKit Descriptor Calculation< 1 %
Loop End< 1 %- k-Means< 1 %
String To Number< 1 %- Column Aggregator< 1 %
- Lag Column< 1 %
- Unpivot< 1 %
- Table Difference Checker< 1 %
CSV Writer< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Interactive Histogram (legacy)< 1 %
- Breakpoint< 1 %
PCA< 1 %Cell Replacer< 1 %- Number to String< 1 %
- Table Validator (Reference)< 1 %
- Constant Value Column Filter< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Value Counter< 1 %
- Interactive Table (legacy)< 1 %
Excel Sheet Appender (XLS)< 1 %Python Script (1⇒1)< 1 %Python Script (2⇒2)< 1 %- R View (Table)< 1 %
- RDKit Canon SMILES< 1 %
- Plate Heatmap Viewer< 1 %
- Fingerprints Expander< 1 %
- Create Collection Column< 1 %
- Upload (legacy)< 1 %
Table Row to Variable< 1 %- Table Row to Variable< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %- Table Row to Variable Loop Start< 1 %
- RProp MLP Learner< 1 %
- Linear Regression Learner< 1 %
- SVM Learner< 1 %
- Random Forest Learner< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
Number To String< 1 %- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Linear Correlation< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- Partitioning< 1 %
- Normalizer (PMML)< 1 %
- Number to String (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers< 1 %
- IF Switch< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- SDF Writer< 1 %
- Parameterized DB Query Reader< 1 %
Table to PDF< 1 %- Table to H2O< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- String Matcher< 1 %
- Case Converter< 1 %
Strings To Document< 1 %- Value Selection Configuration< 1 %
- Heatmap (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Rowset Filter< 1 %
- R Snippet< 1 %
- GET Request< 1 %
- POST Request< 1 %
Extract Date&Time Fields< 1 %- Date Field Extractor (legacy)< 1 %
- XGBoost Predictor< 1 %
- Row Splitter (col+)< 1 %
- Remove Empty Rows< 1 %
- Element Filter< 1 %
- RDKit Interactive Table< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Fingerprint< 1 %
RDKit Structure Normalizer< 1 %- Text Classifier Learner< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
ContactsKNIME Hub- excel delete shift cel upKNIME Forum
- Finding the Top 10 Gainer and Losser at Stock with there Historical Data API and JSONKNIME Hub
- Forms - Identifying and ProcessingKNIME Hub
- forum- excel delete shift cel up -modifiedKNIME Forum
- Show all 17 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.