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 Successors
- Column Filter6 %
- Correlation Filter4 %
- Linear Correlation3 %
- Missing Value3 %
- Excel Writer2 %
- Reference Column Filter2 %
Row Filter (deprecated)2 %- Missing Value Column Filter2 %
- Concatenate2 %
- Create Bit Vector1 %
- Joiner1 %
- Constant Value Column1 %
Row Splitter (deprecated)1 %- Column Resorter1 %
- GroupBy1 %
- Statistics1 %
- Line Plot (JavaScript)1 %
- Column Renamer (Dictionary)1 %
- XLS Control Table Generator< 1 %
- Duplicate Row Filter< 1 %
- Filter Apply< 1 %
- Columns to JSON< 1 %
- One to Many< 1 %
Column Rename< 1 %Table Row to Variable< 1 %- Constant Value Column Filter< 1 %
- Table View (JavaScript)< 1 %
- Desirability Ranking< 1 %
Linear Correlation< 1 %- Unpivot< 1 %
- Rule Engine< 1 %
- Numeric Outliers< 1 %
- Column Combiner< 1 %
- Sorter< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Data Explorer< 1 %
- Interactive Table (legacy)< 1 %
- DB Writer< 1 %
- Create Collection Column< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Rename (Regex)< 1 %
- Partitioning< 1 %
Excel Sheet Appender (XLS)< 1 %- Weka Predictor (3.7)< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- PCA< 1 %
- Column Comparator< 1 %
- Column Appender< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- RowID< 1 %
- Shuffle< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- JSON to Table< 1 %
- ARFF Writer< 1 %
- CSV Writer< 1 %
- Table Writer< 1 %
- Random Forest Learner< 1 %
- Number to String< 1 %
- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Low Variance Filter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
- Rank Correlation< 1 %
- Extract Table Dimension< 1 %
- Conditional Box Plot (legacy)< 1 %
- Capture Workflow End< 1 %
Excel Sheet Appender (XLS)< 1 %- String to Date&Time< 1 %
- Breakpoint< 1 %
CSV Writer< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Loop End< 1 %
- Loop End (Column Append)< 1 %
- X-Partitioner< 1 %
- k-Means< 1 %
- Decision Tree Learner< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Learner< 1 %
- PCA Apply< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Cell Splitter< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Domain Calculator< 1 %
- Reference Column Splitter< 1 %
Joiner< 1 %- Pivot< 1 %
- Missing Value (Apply)< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Splitter< 1 %
- Independent groups t-test< 1 %
- IF Switch< 1 %
- Interactive Histogram (legacy)< 1 %
- Color Manager< 1 %
- Molecule Type Cast< 1 %
- Similarity Search< 1 %
- Column Expressions< 1 %
- Table to H2O< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Fingerprints< 1 %
Table Row to Variable< 1 %- Feature Selection Filter< 1 %
Concatenate (Optional in)< 1 %Column Filter< 1 %- Reference Row Splitter< 1 %
- Row Sampling< 1 %
- End IF< 1 %
- Box Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Bar Chart (JavaScript)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- R View (Table)< 1 %
Table Writer< 1 %- Java Snippet< 1 %
- Column Auto Type Cast< 1 %
- Category to Number< 1 %
- Row Filter (Labs)< 1 %
- Extract Table Spec< 1 %
- Numeric Distances< 1 %
- RDKit From Molecule< 1 %
Database Writer< 1 %Counting Loop Start< 1 %- Naive Bayes Predictor< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
Scorer< 1 %- Tree Ensemble Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Many to One< 1 %
- Table Validator (Reference)< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply Row Splitter< 1 %
- Table Difference Finder< 1 %
- Rule Engine (Dictionary)< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Line Plot (legacy)< 1 %
- Shape Manager< 1 %
- SDF Writer< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Pie/Donut Chart (JavaScript)< 1 %
- Boosting Learner Loop Start< 1 %
- HeatMap (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Category to Class< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
- RDKit Salt Stripper< 1 %
- Domain - Similarity< 1 %
- Fingerprint From Set Bits list< 1 %
- Normalize Plates (Z-Score)< 1 %
- Outlier Removal< 1 %
PBAC Scorer< 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 %Image Writer (Table Column)< 1 %Parameterized Database Query< 1 %- Java Edit Variable< 1 %
Loop End< 1 %Recursive Loop End< 1 %- X-Aggregator< 1 %
Naive Bayes Learner< 1 %- Fuzzy Rule Learner< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %PCA< 1 %- Logistic Regression Predictor< 1 %
- Regression Predictor< 1 %
- Scorer< 1 %
- Entropy Scorer< 1 %
- SMOTE< 1 %
- Association Rule Learner< 1 %
- PCA Compute< 1 %
Gradient Boosted Trees Learner< 1 %- Add Empty Rows< 1 %
- Binner (Dictionary)< 1 %
Cell Replacer< 1 %- Cell Splitter By Position< 1 %
- Category to Number (Apply)< 1 %
Number To String< 1 %String To Number< 1 %Column Appender< 1 %- Lag Column< 1 %
- Table Validator< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Interactive HiLite Collector< 1 %
- Normalizer (Apply)< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %- Number to String (PMML)< 1 %
String To Number (PMML)< 1 %- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
String Replace (Dictionary)< 1 %- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- Numeric Outliers (Apply)< 1 %
- One-way ANOVA< 1 %
- Single sample t-test< 1 %
- Linear Discriminant Analysis Compute< 1 %
- Empty Table Switch< 1 %
- Cache< 1 %
- Crosstab< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Table to Spark< 1 %
DB Table Creator< 1 %- Counter Generation< 1 %
- One Row to Many< 1 %
- Matrix Distance< 1 %
- Distance Matrix Calculate< 1 %
- TensorFlow Network Executor< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Spark Line Appender< 1 %
- String Matcher< 1 %
- Document Viewer< 1 %
- Column Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Container Output (Table)< 1 %
- Container Output (JSON)< 1 %
- Variance Filter< 1 %
- Python Learner (legacy)< 1 %
- GET Request< 1 %
- Date&Time Difference< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time Shift< 1 %
- Modify Time< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- Weak Label Model Learner< 1 %
XGBoost Tree Ensemble Learner< 1 %- XGBoost Predictor< 1 %
- XGBoost Predictor (Regression)< 1 %
Table to HTML String< 1 %- Lipinski's Rule-of-Five< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Diversity Picker< 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.