This node removes all columns from the input table which contain more missing values than a certain percentage. The filtering is only applied to the columns in the input list of the column filter panel.
Options
Manual Selection
Wildcard/Regex Selection
Type Selection
Popular Predecessors
- Column Filter7 %
- CSV Reader7 %
- Row Filter5 %
- Excel Reader5 %
- Statistics4 %
- Missing Value4 %
- Joiner3 %
- Table Creator3 %
- Pivot3 %
Number To String2 %- File Reader (Complex Format)2 %
- String Manipulation2 %
- Duplicate Row Filter2 %
- Concatenate2 %
- File Reader2 %
- GroupBy2 %
- Number to String1 %
- String to Number1 %
- Rule Engine1 %
- Rule-based Row Filter1 %
- Row Splitter1 %
- Missing Value Column Filter1 %
Column Rename1 %- Column Resorter1 %
- Missing Value (Apply)< 1 %
- Data Explorer< 1 %
- String to Date&Time< 1 %
- Column Auto Type Cast< 1 %
- Constant Value Column Filter< 1 %
- Cell Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Numeric Outliers< 1 %
- Reference Row Filter< 1 %
Column Appender< 1 %- Sorter< 1 %
- Table Transposer< 1 %
Linear Correlation< 1 %- Math Formula< 1 %
XLS Reader< 1 %Concatenate (Optional in)< 1 %- Rule-based Row Splitter< 1 %
- Column Splitter< 1 %
- DB Query Reader< 1 %
- Column Renamer< 1 %
- Nominal Value Row Filter< 1 %
- Loop End< 1 %
- Column Appender< 1 %
- Group Loop Start< 1 %
- Constant Value Column< 1 %
Cell Splitter< 1 %Excel Reader (XLS)< 1 %- Extract Missing Value Cause< 1 %
- Chunk Loop Start< 1 %
- Loop End (Column Append)< 1 %
Joiner< 1 %- Normalizer< 1 %
- Color Manager< 1 %
- Column Expressions< 1 %
- Table Reader< 1 %
- Math Formula (Multi Column)< 1 %
- Extract Date&Time Fields< 1 %
- Partitioning< 1 %
- Table Manipulator< 1 %
- Reference Column Filter< 1 %
- Ungroup< 1 %
Number To String (PMML)< 1 %- Unpivot< 1 %
- Scorer< 1 %
- Nominal Value Row Splitter< 1 %
Python Script (1⇒1)< 1 %- DB Reader< 1 %
- Python Script (legacy)< 1 %
- Column Rename (Regex)< 1 %
- Round Double< 1 %
- Filter Apply< 1 %
Cell Replacer< 1 %- RowID< 1 %
- Value Counter< 1 %
- R Snippet< 1 %
- Date&Time-based Row Filter< 1 %
- Table Editor (JavaScript)< 1 %
- k-Means< 1 %
- Reference Column Splitter< 1 %
- Filter Apply Row Splitter< 1 %
- Regex Split< 1 %
- Table View (JavaScript)< 1 %
Table Row to Variable< 1 %- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
- String Replacer< 1 %
- JSON to Table< 1 %
- Column to Grid< 1 %
- Row Filter (Labs)< 1 %
- Rank Correlation< 1 %
- Numeric Binner< 1 %
- Row Sampling< 1 %
- Box Plot (legacy)< 1 %
- Table Row to Variable< 1 %
Table Reader< 1 %Numeric Scorer< 1 %- Auto-Binner< 1 %
- Case Converter< 1 %
- Linear Correlation< 1 %
- Number to String (PMML)< 1 %
File Reader< 1 %- SVM Predictor< 1 %
- Category to Number< 1 %
- Double to Integer< 1 %
- Normalizer (PMML)< 1 %
- Legacy Date&Time to Date&Time< 1 %
Recursive Loop End< 1 %- SMOTE< 1 %
- Molecule Type Cast< 1 %
- Nominal Row Filter Configuration< 1 %
- Modify Time< 1 %
CSV Reader< 1 %- Decision Tree Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Column Merger< 1 %
- One to Many< 1 %
- Domain Calculator< 1 %
Read Excel Sheet Names (XLS)< 1 %- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- SDF Reader< 1 %
Excel Reader (XLS)< 1 %- Scatter Plot (JavaScript)< 1 %
- Integer Widget< 1 %
- Value Lookup< 1 %
- Split Collection Column< 1 %
Database Connector< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Hierarchical Clustering< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Lag Column< 1 %
- Cross Joiner< 1 %
- Edit Numeric Domain< 1 %
- Reference Row Splitter< 1 %
- Low Variance Filter< 1 %
- Shuffle< 1 %
- Empty Table Switch< 1 %
- R to Table< 1 %
- String to Date/Time (legacy)< 1 %
- Advanced MolConverter< 1 %
- Naive Bayes Predictor< 1 %
- Regression Predictor< 1 %
- Table Validator (Reference)< 1 %
- Google Sheets Reader< 1 %
- GET Request< 1 %
- Moving Aggregator< 1 %
- XPath< 1 %
- Remove Empty Rows< 1 %
- Recursive Loop End< 1 %
- String Matcher< 1 %
- Variable Expressions< 1 %
- ARFF Reader< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Association Rule Learner< 1 %
String To Number< 1 %- Correlation Filter< 1 %
- Interactive HiLite Collector< 1 %
Rank Correlation< 1 %Excel Reader (XLS)< 1 %- Tika Parser< 1 %
- Integer Input (legacy)< 1 %
Extract Date&Time Fields< 1 %- RDKit From Molecule< 1 %
- Simple Regression Tree Predictor< 1 %
- Reference Column Resorter< 1 %
- Top k Row Filter< 1 %
- End IF< 1 %
Color Appender< 1 %- Double Configuration< 1 %
- Column Filter (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- JSON Path< 1 %
- RDKit Descriptor Calculation< 1 %
- Row Splitter (Labs)< 1 %
- Extract Table Spec< 1 %
- Files/Folders Meta Info< 1 %
- Salesforce Simple Query< 1 %
- Row to Column Names< 1 %
- Table Difference Finder< 1 %
- CASE Switch End< 1 %
- Parameterized DB Query Reader< 1 %
- R Snippet< 1 %
Database Reader< 1 %- Bootstrap Sampling< 1 %
Python Source< 1 %- Extract Time Window (legacy)< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Column Filter (PMML)< 1 %
- String to Number (PMML)< 1 %
- Numeric Outliers (Apply)< 1 %
- Table Column to Variable< 1 %
- Line Reader< 1 %
- Logistic Regression Predictor< 1 %
- Linear Regression Learner< 1 %
- Target Shuffling< 1 %
- Cache< 1 %
- Parallel Chunk Start< 1 %
- Java IF (Table)< 1 %
- Double Input (legacy)< 1 %
- R Source (Table)< 1 %
- Normalize Plates (POC)< 1 %
- Normalize Plates (Z-Score)< 1 %
- Logistic Regression Learner< 1 %
- Entropy Scorer< 1 %
- Random Forest Predictor< 1 %
- Number to Category (Apply)< 1 %
- Table Validator< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
String To Number (PMML)< 1 %- Cronbach Alpha< 1 %
- Counter Generation< 1 %
- Java Snippet (simple)< 1 %
- Tika Parser URL Input< 1 %
- Dictionary Replacer (File-based)< 1 %
- Container Input (Table)< 1 %
- Window Loop Start< 1 %
- RDKit Fingerprint< 1 %
- Variable to Table Column< 1 %
- One to Many (PMML)< 1 %
- Column Filter Configuration< 1 %
- Single Selection Configuration< 1 %
- Double Widget< 1 %
Table Column to Variable< 1 %- Column List Loop Start< 1 %
PCA< 1 %Logistic Regression Learner< 1 %- Equal Size Sampling< 1 %
String Replace (Dictionary)< 1 %- Lift Chart (legacy)< 1 %
- Save Workflow< 1 %
- Tag Filter< 1 %
- Moving Average< 1 %
- 3D WHIM< 1 %
- Navigate< 1 %
- Wait...< 1 %
Variable to Table Column< 1 %Parameterized Database Query< 1 %Line Reader< 1 %- Fuzzy Rule Predictor< 1 %
- Decision Tree Learner< 1 %
- PCA< 1 %
- Cell Splitter By Position< 1 %
- String Manipulation (Variable)< 1 %
- Conditional Box Plot (legacy)< 1 %
- Similarity Search< 1 %
- Math Formula (Variable)< 1 %
- Replacer< 1 %
- Strings to Document< 1 %
- Table to JSON< 1 %
- Row Splitter (col+)< 1 %
- Range Filter< 1 %
- Fixed Width File Reader< 1 %
- Numeric Scorer< 1 %
- HiLite Row Splitter< 1 %
Parquet Reader< 1 %- Interactive Value Filter Widget< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- Outlier Removal< 1 %
- PubChem Search< 1 %
- String to URI< 1 %
Variable to Table Row< 1 %Database Connection Table Reader< 1 %Loop End (2 ports)< 1 %Recursive Loop Start< 1 %- X-Aggregator< 1 %
- X-Partitioner< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
- Column Name Extractor< 1 %
- Rank< 1 %
Linear Discriminant Analysis< 1 %- IF Switch< 1 %
- Extract Table Dimension< 1 %
- k-Medoids< 1 %
- JPython Function (Legacy)< 1 %
- Java Snippet Row Filter< 1 %
- Word Vector Apply (legacy)< 1 %
- Case Converter< 1 %
- List Box Input (legacy)< 1 %
- Feature Calculator (BETA)< 1 %
- Parameter Optimization Loop Start< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Date< 1 %
- Mask Date/Time (legacy)< 1 %
Dumb Joiner< 1 %- RDKit Optimize Geometry< 1 %
- Window Slider< 1 %
- Distance (2-D)< 1 %
- Fingerprints Expander< 1 %
Exploration/Exploitation Scorer< 1 %- File Meta Info (legacy)< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Looping< 1 %Simple File Reader< 1 %Line Reader< 1 %List Files< 1 %Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %Naive Bayes Predictor< 1 %- PNN Predictor< 1 %
- Random Forest Learner< 1 %
- Binner (Dictionary)< 1 %
- Expand Bit Vector< 1 %
- Category to Number (Apply)< 1 %
Double To Int< 1 %- Numeric Binner (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %Merge Variables< 1 %- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Spark to Table< 1 %
- Random Number Assigner< 1 %
- Boosting Predictor Loop End< 1 %
PMML Predictor< 1 %- Geo-Coordinate Row Filter< 1 %
- SAS7BDAT Reader< 1 %
Excel Sheet Appender (XLS)< 1 %- Spark Line Appender< 1 %
- Markup Tag Filter< 1 %
- Dictionary Tagger< 1 %
- Document Data Extractor< 1 %
Strings To Document< 1 %- Weka Cluster Assigner (3.7)< 1 %
- JPMML Regression Predictor< 1 %
- Date&Time Configuration< 1 %
- File Chooser (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Column Filter Widget< 1 %
- Slider Widget< 1 %
- String to JSON< 1 %
- Container Input (JSON)< 1 %
JSON Reader< 1 %Python Script (2⇒1)< 1 %- UNIX Timestamp to Date&Time< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- Column to XML< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- Google Address Geocoder< 1 %
- Latitude/Longitude to Coordinate< 1 %
Regex Extractor< 1 %Read MDB< 1 %IF Switch (Flow Variable Value)< 1 %- List Folders< 1 %
- Number Formatter< 1 %
- Create Collection Column< 1 %
- Binary Objects to Files< 1 %
- Binary Objects to Strings< 1 %
- Try (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
- Counting Loop Start< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Create Table Structure< 1 %
- Friedman Test< 1 %
- Capture Workflow Start< 1 %
- Workflow Executor< 1 %
- DB Table Creator< 1 %
- Empty Table Creator< 1 %
- Read Excel Sheet Names< 1 %
- RSS Feed Reader< 1 %
- Integer Configuration< 1 %
- Single Selection Widget< 1 %
- JSON Path (Dictionary)< 1 %
- CDK to Molecule< 1 %
- RDKit Canon SMILES< 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
- 01 Train a Feed Forward Neural NetworkKNIME Hub
- 01 Train a Feed Forward Neural NetworkKNIME Hub
- Show all 484 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.