The node tests each selected column for missing values and removes the column if it meets the specified condition about the number of missing values. Each column that is not selected for the test is passed on to the output unconditionally.
Options
Popular Successors
- Missing Value7 %
- Column Filter6 %
- Joiner4 %
Row Filter (deprecated)3 %- Excel Writer3 %
- GroupBy2 %
Scorer2 %- Partitioning2 %
- Duplicate Row Filter1 %
- Column Resorter1 %
Column Rename1 %- String Manipulation1 %
- Statistics1 %
- Math Formula1 %
- Rule Engine1 %
- CSV Writer1 %
- Table Transposer1 %
- Reference Column Filter< 1 %
- Concatenate< 1 %
Row Splitter (deprecated)< 1 %- Constant Value Column Filter< 1 %
- Rule-based Row Filter< 1 %
- Sorter< 1 %
- Constant Value Column< 1 %
- Statistics View< 1 %
- String to Number< 1 %
- Normalizer< 1 %
Variable to Table Column< 1 %Cell Splitter< 1 %- Numeric Outliers< 1 %
- Number to String< 1 %
- Nominal Value Row Filter< 1 %
- String to Date&Time< 1 %
- Column Aggregator< 1 %
- Linear Correlation< 1 %
- Missing Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
K Nearest Neighbor< 1 %PCA< 1 %- Rule-based Row Splitter< 1 %
- Column Expressions< 1 %
- Column Auto Type Cast< 1 %
- Number Rounder< 1 %
- Rank Correlation< 1 %
- Loop End< 1 %
Random Forest Learner< 1 %- Cell Splitter< 1 %
- Reference Row Filter< 1 %
- Pivot< 1 %
- Column List Loop Start< 1 %
Naive Bayes Learner< 1 %PCA Compute< 1 %Random Forest Predictor< 1 %- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- RowID< 1 %
- DBSCAN< 1 %
Normalizer< 1 %Table Column to Variable< 1 %- Loop End (Column Append)< 1 %
- Column Combiner< 1 %
- Extract Missing Value Cause< 1 %
- String Manipulation (Multi Column)< 1 %
- Distance Matrix Calculate< 1 %
- k-Means< 1 %
- Logistic Regression Learner< 1 %
- Column Renamer (Dictionary)< 1 %
- Reference Column Splitter< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- k-Medoids< 1 %
- RDKit Descriptor Calculation< 1 %
- Table Row to Variable Loop Start< 1 %
- Histogram (legacy)< 1 %
- Table to R< 1 %
- Correlation Filter< 1 %
- Low Variance Filter< 1 %
- Extract Table Dimension< 1 %
- Conditional Box Plot (legacy)< 1 %
- Numeric Distances< 1 %
Excel Writer (XLS)< 1 %- Weka Predictor (3.7)< 1 %
Naive Bayes Predictor< 1 %Random Forest Learner< 1 %- Random Forest Predictor< 1 %
Number To String (PMML)< 1 %- Line Chart (JFreeChart)< 1 %
- Variable to Table Column< 1 %
Loop End< 1 %- Decision Tree Predictor< 1 %
- One to Many< 1 %
- Value Counter< 1 %
Linear Discriminant Analysis< 1 %- Scatter Plot (legacy)< 1 %
- DB Writer< 1 %
- Feature Selection Filter< 1 %
- X-Partitioner< 1 %
- Scorer< 1 %
- Cell Splitter By Position< 1 %
- Column Renamer< 1 %
- Column Appender< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Splitter< 1 %
- String to Number (PMML)< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Data Explorer< 1 %
- End IF< 1 %
- Color Manager< 1 %
- String Distances< 1 %
- Column Filter (legacy)< 1 %
- Object Inserter< 1 %
Extract Date&Time Fields< 1 %Regex Extractor< 1 %- Java Snippet< 1 %
- Numeric Scorer< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Extract Table Spec< 1 %
- String Matcher< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- R Snippet< 1 %
- Create Collection Column< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Column to Grid< 1 %
String To Number (PMML)< 1 %- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
String Replace (Dictionary)< 1 %- Numeric Outliers (Apply)< 1 %
- Bar Chart< 1 %
- Table to Spark< 1 %
- Math Formula (Multi Column)< 1 %
- Heatmap (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Table Difference Checker< 1 %
- Date&Time Difference< 1 %
IF Switch (Flow Variable Value)< 1 %- Inject Variables (Data)< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
PCA Apply< 1 %- PCA Apply< 1 %
- Table Validator (Reference)< 1 %
- String Splitter (Regex)< 1 %
- Rule Engine (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Histogram< 1 %
- Table View< 1 %
- One Row to Many< 1 %
- Line Plot (Plotly)< 1 %
- Table to H2O< 1 %
Excel Writer (XLS)< 1 %- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- Breakpoint< 1 %
- Fuzzy c-Means< 1 %
- Association Rule Learner< 1 %
- Random Forest Learner< 1 %
Column Appender< 1 %- Double to Integer< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Number to String (PMML)< 1 %
- Rank< 1 %
- Shuffle< 1 %
- Renderer to Image< 1 %
- Interactive Pie chart (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Box Plot< 1 %
- DB Update< 1 %
- Keras Network Learner< 1 %
- R Learner< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- StringCell To File< 1 %
- Remove Empty Rows< 1 %
- Fingerprint Similarity< 1 %
- Domain - Similarity< 1 %
- Create Well Position< 1 %
- Outlier Removal< 1 %
- ARIMA Learner< 1 %
- Table Row to Variable< 1 %
- Table to Image< 1 %
- Table Writer< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop End< 1 %- Naive Bayes Learner< 1 %
- PNN Predictor< 1 %
- Decision Tree Learner< 1 %
- K Nearest Neighbor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
- Regression Predictor< 1 %
- SMOTE< 1 %
- PCA Compute< 1 %
- PCA< 1 %
- Gradient Boosted Trees Learner< 1 %
Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Bootstrap Sampling< 1 %
- Case Converter< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- One to Many (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Reference Column Resorter< 1 %
- Row Aggregator< 1 %
- Row to Column Names< 1 %
- Row Sampling< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Table Difference Finder< 1 %
- Target Shuffling< 1 %
- Value Lookup< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Crosstab< 1 %
- Interactive Histogram (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Pie Chart< 1 %
- Scatter Plot< 1 %
- Molecule Type Cast< 1 %
- SDF Writer< 1 %
- DB Insert< 1 %
- DB Looping< 1 %
- DB Table Creator< 1 %
- Similarity Search< 1 %
- Bar Chart (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- Variable Expressions< 1 %
- HeatMap (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
XLS Writer< 1 %- Excel Cell Updater< 1 %
- Send to Tableau Server< 1 %
- Tableau Writer< 1 %
- Case Converter< 1 %
- Strings to Document< 1 %
- Google Sheets Updater< 1 %
- Nominal Row Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Columns to JSON< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Table to HTML String< 1 %
- BERT Classification Learner< 1 %
- TIBCO Spotfire File Writer< 1 %
- Multiport Loop End< 1 %
- R Snippet< 1 %
- 2D/3D Scatterplot< 1 %
Backward Feature Elimination End< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %- Naive Bayes Predictor< 1 %
- PNN Learner (DDA)< 1 %
Decision Tree Learner< 1 %- SVM Predictor< 1 %
Simple Regression Tree Learner< 1 %- Tree Ensemble Predictor (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Create Bit Vector< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- HiLite Row Splitter< 1 %
- Interactive HiLite Collector< 1 %
- Column Filter (PMML)< 1 %
- Paired t-test< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Java IF (Table)< 1 %
- Spark Line Appender< 1 %
Strings To Document< 1 %- Interactive Range Slider Filter Widget< 1 %
- HTTP Retriever< 1 %
- Fingerprint to Set Bits List< 1 %
- MolConverter< 1 %
- Desirability Ranking< 1 %
Auto Active Learn Loop End< 1 %- PNGs to Binary Objects< 1 %
- URI to Port< 1 %
Table Row to Variable< 1 %Parameterized Database Query< 1 %Interval Loop Start< 1 %- Hierarchical Cluster View< 1 %
- Decision Tree to Image< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Binner (Dictionary)< 1 %
- Create Byte Vector< 1 %
- CAIM Binner< 1 %
- Edit Nominal Domain< 1 %
Missing Value< 1 %- Numeric Binner (PMML)< 1 %
- Top k Row Filter< 1 %
- Numeric Median Test< 1 %
- Cronbach Alpha< 1 %
CASE Switch Data (End)< 1 %Color Appender< 1 %- Mahalanobis Distance< 1 %
- Scatter Plot (Plotly)< 1 %
- Stacked Area Chart (JavaScript)< 1 %
PMML Predictor< 1 %- Topic Extractor (Parallel LDA)< 1 %
- String to Path< 1 %
- JPMML Classifier< 1 %
- Column Selection Configuration< 1 %
- Add Table to R< 1 %
- Modify Time< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Window Function< 1 %
- Extract Column Properties< 1 %
Expand Well Position< 1 %- Active Branch Inverter< 1 %
Variable to Table Column< 1 %- ARFF Writer< 1 %
CSV Writer< 1 %Database Update< 1 %Database Writer< 1 %- Fuzzy Rule Predictor< 1 %
Numeric Scorer< 1 %- SVM Learner< 1 %
Tree Ensemble Learner< 1 %Random Forest Learner (Regression)< 1 %Gradient Boosted Trees Predictor< 1 %- Category to Number (Apply)< 1 %
String To Number< 1 %Linear Correlation< 1 %- Shapiro-Wilk Test< 1 %
- Independent groups t-test< 1 %
- Cache< 1 %
- HiLite Table (legacy)< 1 %
- DB Connector< 1 %
- Parameterized DB Query Reader< 1 %
- Counter Generation< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Number Assigner< 1 %
- Bit Vector Distances< 1 %
- Box Plot (JavaScript)< 1 %
- Histogram (JavaScript)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- PMML Predictor< 1 %
Table to PDF< 1 %- MoSS< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
Excel Sheet Appender (XLS)< 1 %- Send to Power BI< 1 %
- Java Snippet (simple)< 1 %
Word Vector Learner (legacy)< 1 %- Tika Language Detector< 1 %
- RegEx Filter< 1 %
- t-SNE (L. Jonsson)< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Column Filter Configuration< 1 %
- JSON Column Combiner< 1 %
- Table to JSON< 1 %
JSON Writer< 1 %Python Script (2⇒1)< 1 %- Date&Time to legacy Date&Time< 1 %
- Extract Duration Fields< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
XGBoost Linear Ensemble Learner (Regression)< 1 %- XPath< 1 %
- Molecule to CDK< 1 %
- Information Gain Calculator< 1 %
Location Extractor< 1 %- Form Encoded HTTP Entity Creator< 1 %
- Time Domain Features (TDF)< 1 %
- XLS Control Table Generator< 1 %
- Substructure Matcher< 1 %
- Domain - Leverage< 1 %
- Notched Boxplot (JFreechart)< 1 %
- Empty Collection to Missing< 1 %
- Missing to Empty Collection< 1 %
- Combine Columns by Header< 1 %
- Normalize Plates (Z-Score)< 1 %
- Multivariate Z-Primes< 1 %
- Z-Primes (PC x NC)< 1 %
- Elemental Analysis< 1 %
- pKa< 1 %
Element Selector< 1 %- ARIMA Visualization< 1 %
- Split Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Copy/Move Files (legacy)< 1 %
- Strings to Binary Objects< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- Variable to Table Row< 1 %
Database Looping< 1 %Database Table Creator< 1 %- CSV Reader< 1 %
Table Writer< 1 %Backward Feature Elimination Start (1:1)< 1 %Variable Condition Loop End< 1 %- Generic Loop Start< 1 %
Variable Loop End< 1 %- X-Aggregator< 1 %
- Silhouette Coefficient< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
k-Means< 1 %- MDS< 1 %
- OPTICS Cluster Compute< 1 %
Logistic Regression Learner< 1 %Regression Predictor< 1 %- SOTA Predictor< 1 %
Random Forest Predictor< 1 %Simple Regression Tree Predictor< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Predictor< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
Tree Ensemble Learner< 1 %- Tree Ensemble Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor (Regression)< 1 %
- Simple Regression Tree Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Expand Bit Vector< 1 %
- Column Comparator< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %- Edit Numeric Domain< 1 %
- Row Splitter (Labs)< 1 %
- Denormalizer (PMML)< 1 %
Normalizer (PMML)< 1 %- Set Operator< 1 %
Rank Correlation< 1 %- Kaplan-Meier Estimator< 1 %
- Kruskal-Wallis Test< 1 %
- Single sample t-test< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Linear Discriminant Analysis< 1 %
CASE Switch Data (Start)< 1 %- Enrichment Plotter (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Save Workflow< 1 %
- SDF Stripper< 1 %
- Mol2 Writer< 1 %
- Parallel Chunk End< 1 %
MySQL Connector< 1 %- DB Loader< 1 %
- DB Merge< 1 %
- DB Transaction Start< 1 %
DB Table Creator< 1 %- One Rule Inserter< 1 %
- Matrix Distance< 1 %
- Distance Matrix Writer< 1 %
K Nearest Neighbor (Distance Function)< 1 %- K Nearest Neighbor (Distance Function)< 1 %
- Continuous Error Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Model Loop Start< 1 %
- Boosting Learner Loop Start< 1 %
- Table to PMML Ensemble< 1 %
- Cell to PMML< 1 %
- DL4J Feedforward Predictor (Layer) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Math Formula (Variable)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Interval Chart (JFreeChart)< 1 %
- JPython Function (Legacy)< 1 %
- LIBSVMPredictor< 1 %
- Geo-Coordinate Row Filter< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %TIBCO File Writer< 1 %- Java Snippet Row Filter< 1 %
- Radar Plot Appender< 1 %
- Word2Vec Learner (legacy)< 1 %
- Frequency Filter< 1 %
- TF< 1 %
- Category to Class< 1 %
- Punctuation Erasure< 1 %
Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
Document Data Extractor< 1 %- Document Data Extractor< 1 %
- Document Vector< 1 %
- Sentence Extractor< 1 %
- Document Viewer< 1 %
- Tag Cloud< 1 %
- Value Selection Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Column Selection Widget< 1 %
- JSON Transformer< 1 %
- Extract Outline Labeling< 1 %
- Assign Partition< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %Python Script (1⇒1)< 1 %Python Script (1⇒2)< 1 %- Python View (legacy)< 1 %
- R View (Table)< 1 %
- GET Request< 1 %
- Date&Time Shift< 1 %
- Modify Date< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Weak Label Model Predictor< 1 %
XGBoost Tree Ensemble Learner< 1 %- XGBoost Predictor (Regression)< 1 %
- XML Column Combiner< 1 %
- Column to XML< 1 %
- String to XML< 1 %
- Discretise< 1 %
Table to HTML String< 1 %- Molecular Properties< 1 %
- Fingerprints< 1 %
- RDKit Add Hs< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Interactive Table< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit To Molecule< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Substructure Counter< 1 %
- MapQuest Geocoder< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Hash Calculator< 1 %
Views
- This node has no views
Workflows
00 Data GenerationKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 01 Train a Feed Forward Neural NetworkKNIME Hub
- Show all 558 workflows
Links
- put an xml and csv file togehterby armingrudd on 2019-07-16forum.knime.com/p/65637
- excluding columns with ‘NaN’by aworker on 2023-02-20forum.knime.com/p/194186
- Keep only cells with value in a table with multiple columnsby armingrudd on 2019-04-29forum.knime.com/p/59672
- Filter out categorical fieldsby HansS on 2019-07-14forum.knime.com/p/65351
- Automating Column Selection based on Statistics node output?by HansS on 2022-05-16forum.knime.com/p/157019
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.