This node filters columns exclusively containing duplicates of the same value from the input data table. Examples include a column containing only zeroes, a column containing only identical Strings, or a column comprising only missing cells. In a dialog window, you can select which columns to apply the filter to (with all columns selected by default). From these selected columns, you can choose to remove either all constant value columns or columns containing only specific constant numeric, String, or missing values. Finally, you can also specify the minimum number of rows a table must have to be considered for filtering.
Options
Popular Predecessors
- Column Filter6 %
- CSV Reader6 %
- Missing Value Column Filter4 %
Excel Reader (XLS)3 %- Constant Value Column3 %
- Missing Value2 %
Row Filter (deprecated)2 %- Reference Column Filter2 %
Column Rename2 %- Rule-based Row Filter2 %
CSV Reader1 %- GroupBy1 %
- Joiner1 %
- Table Row to Variable1 %
- Numeric Outliers1 %
Python Script (1⇒1)1 %- Excel Reader1 %
- Sorter1 %
Number To String1 %- Loop End1 %
- Cell Splitter< 1 %
- Numeric Binner< 1 %
- String Manipulation< 1 %
Table Reader< 1 %- Constant Value Column Filter< 1 %
- Math Formula< 1 %
- Ungroup< 1 %
- Value Counter< 1 %
- Color Manager< 1 %
Regex Extractor< 1 %- Column Resorter< 1 %
- Nominal Value Row Filter< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Duplicate Row Filter< 1 %
- String Replacer< 1 %
- String to Date&Time< 1 %
Joiner< 1 %- Group Loop Start< 1 %
- Column Expressions< 1 %
- Column Appender< 1 %
- String Manipulation (Multi Column)< 1 %
- Double to Integer< 1 %
- Pivot< 1 %
- Number Rounder< 1 %
- End IF< 1 %
- DB Reader< 1 %
- Distance Matrix Calculate< 1 %
- Table View (JavaScript)< 1 %
- JSON to Table< 1 %
- Data Explorer< 1 %
- HTTP Result Data Extractor< 1 %
- GET Request< 1 %
- Row Filter (Labs)< 1 %
- Concatenate< 1 %
String To Number< 1 %- Reference Row Filter< 1 %
- Column Splitter< 1 %
- Rule Engine< 1 %
Table Row To Variable Loop Start< 1 %- Column Renamer (Dictionary)< 1 %
- DB Query Reader< 1 %
- Lipinski's Rule-of-Five< 1 %
- RDKit Fingerprint< 1 %
- File Reader (Complex Format)< 1 %
Cell Replacer< 1 %File Reader< 1 %- Table Creator< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- Low Variance Filter< 1 %
- Statistics< 1 %
- Math Formula (Multi Column)< 1 %
- Auto-Binner< 1 %
- Column Combiner< 1 %
- Category to Number (Apply)< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Column Rename (Regex)< 1 %
Row Splitter (deprecated)< 1 %- Normalizer< 1 %
- Partitioning< 1 %
- RowID< 1 %
- Table Transposer< 1 %
- Rule-based Row Splitter< 1 %
- IF Switch< 1 %
- Date&Time-based Row Filter< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Substructure Counter< 1 %
- File Reader< 1 %
- Add Empty Rows< 1 %
- Edit Numeric Domain< 1 %
- Table Manipulator< 1 %
- Unpivot< 1 %
- Generic Loop Start< 1 %
- DBSCAN< 1 %
- Column Renamer< 1 %
- Empty Table Switch< 1 %
- Category to Number< 1 %
Column Appender< 1 %- Counter Generation< 1 %
- Java Edit Variable< 1 %
- Chunk Loop Start< 1 %
- One to Many< 1 %
- Filter Apply< 1 %
- Capture Workflow Start< 1 %
- Column Filter (legacy)< 1 %
- Reference Row Splitter< 1 %
- Crosstab< 1 %
- Catch Errors (Data Ports)< 1 %
- Cross Joiner< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Split Collection Column< 1 %
List Files< 1 %- Java Snippet< 1 %
- Column List Loop Start< 1 %
- Number to String< 1 %
- Row Sampling< 1 %
- Numeric Outliers (Apply)< 1 %
- Data Generator< 1 %
- Parallel Chunk End< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- RDKit Add Conformers< 1 %
- Interactive Value Filter Widget< 1 %
- String to Duration< 1 %
- Date&Time Part Extractor< 1 %
Numeric Scorer< 1 %Cell Splitter< 1 %- Container Input (Table)< 1 %
Table Row to Variable< 1 %- k-Means< 1 %
- Association Rule Learner< 1 %
Concatenate (Optional in)< 1 %- Case Converter< 1 %
- Column Comparator< 1 %
- Reference Column Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- String Input (legacy)< 1 %
- Table to JSON< 1 %
- Date&Time Difference< 1 %
- Modify Time< 1 %
- Molecular Properties< 1 %
- Outlier Removal< 1 %
- Date&Time Widget< 1 %
- R to Table< 1 %
- Remove Empty Rows< 1 %
Database Reader< 1 %- Loop End (Column Append)< 1 %
- Empty Table Creator< 1 %
- RSS Feed Reader< 1 %
- Normalize Plates (POC)< 1 %
- Envision Reader< 1 %
- MolConverter< 1 %
- Create Collection Column< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Line Reader< 1 %Loop End< 1 %K Nearest Neighbor< 1 %- Column to Grid< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Create Table Structure< 1 %
- Table Validator< 1 %
- Equal Size Sampling< 1 %
String To Number (PMML)< 1 %- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- SDF Reader< 1 %
- Random Label Assigner< 1 %
- PMML to Cell< 1 %
Excel Reader (XLS)< 1 %- NGram Creator< 1 %
- Column Selection Configuration< 1 %
- Value Filter (legacy)< 1 %
- Feature Calculator (BETA)< 1 %
Python Script (2⇒1)< 1 %- UNIX Timestamp to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- Fingerprint Similarity< 1 %
- RDKit Molecule Catalog Filter< 1 %
- Expand Well Position< 1 %
- Variable to Table Row< 1 %
- Table Reader< 1 %
- X-Partitioner< 1 %
- Expand Bit Vector< 1 %
- Edit Nominal Domain< 1 %
- Missing Value (Apply)< 1 %
- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
- Table Difference Finder< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Box Plot (legacy)< 1 %
Color Appender< 1 %- Read Excel Sheet Names< 1 %
- String Configuration< 1 %
- MongoDB Reader< 1 %
- Parameter Optimization Loop Start< 1 %
- Python Script (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Moving Average< 1 %
- Twitter Search< 1 %
Views
- This node has no views
Workflows
00_Topic_Modeling_with_Verified_ComponentsKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- Show all 96 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.