Constant Value Column Filter

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

Remove from the selected columns all constant value columns

Select this option to remove all constant value columns from the columns selected in the Column Selection tab, independent of the specific value they contain in duplicates.

Remove from the selected columns constant value columns that only contain numeric values of

Select this option to remove columns containing only a specific numeric value from the columns selected in the Column Selection tab.

Remove from the selected columns constant value columns that only contain String values of

Select this option to remove columns containing only a specific String value from the columns selected in the Column Selection tab.

Remove from the selected columns constant value columns that only contain missing values

Select this option to remove columns containing only empty cells / missing values from the columns selected in the Column Selection tab.

Minimum number of rows

The minimum number of rows a table must have to be considered for filtering. If the table size is below the specified value, the table will not be filtered / altered.

Apply filter

This list contains the column names of the input table that are to be considered for filtering.

Enforce Inclusion

Select this option to enforce the current "Apply filter" list to stay the same even if the input table specification changes. If some of the listed columns are not available anymore, a warning is displayed. (New columns will automatically be added to the "Do not apply filter" list.)

Do not apply filter (retain column)

This list contains the column names of the input table that are passed to the output without undergoing filtering.

Enforce Exclusion

Select this option to enforce the current "Do not apply filter" list to stay the same even if the input table specification changes. If some of the listed columns are not available anymore, a warning is displayed. (New columns will automatically be added to the "Apply filter" list.)

Input Ports

Table from which columns are to be filtered.

Output Ports

Table excluding filtered columns.

Best Friends (Incoming)

• Column Filter (11 %) Streamable
• Row Filter (8 %) Streamable
• Missing Value Column Filter (7 %) 
• File Reader (4 %) Streamable
• Constant Value Column (4 %) Streamable
• Reference Column Filter (4 %) Streamable
• Column Rename (4 %) Streamable
• Category To Number (3 %) Streamable
• Column Resorter (3 %) Streamable
• Joiner (3 %) 
• Low Variance Filter (3 %) 
• Excel Reader (XLS) (3 %) Streamable
• CSV Reader (2 %) 
• Database Reader (legacy) (2 %) 
• Table Creator (2 %) 
• Concatenate (2 %) Streamable
• Numeric Binner (2 %) Streamable
• String To Number (2 %) StreamableDeprecated
• Column Merger (2 %) Streamable
• GroupBy (2 %) 
• Missing Value (2 %) 
• Sorter (2 %) 
• Rule-based Row Filter (2 %) Streamable
• Statistics (2 %) 
• Counter Generation (2 %) 
• Python Script (1⇒1) (2 %) 
• Catch Errors (Data Ports) (< 1 %) 
• Loop End (Column Append) (< 1 %) 
• Numeric Scorer (< 1 %) Deprecated
• Cell Splitter (< 1 %) Deprecated
• Cell Splitter By Position (< 1 %) Streamable
• Column Auto Type Cast (< 1 %) 
• Column Appender (< 1 %) Streamable
• Cross Joiner (< 1 %) Streamable
• Nominal Value Row Filter (< 1 %) Streamable
• Reference Row Filter (< 1 %) 
• Column Splitter (< 1 %) Streamable
• String Manipulation (< 1 %) Streamable
• Rule Engine (< 1 %) Streamable
• Numeric Outliers (< 1 %) 
• Empty Table Creator (< 1 %) 
• Association Rule Learner (Borgelt) (< 1 %) 
• Math Formula (Multi Column) (< 1 %) Streamable
• RSS Feed Reader (< 1 %) 
• Container Input (Table) (< 1 %) 
• Show all 45 recommendations

Best Friends (Outgoing)

• Missing Value Column Filter (9 %) 
• Column Filter (7 %) Streamable
• Normalizer (6 %) 
• GroupBy (4 %) 
• Constant Value Column (3 %) Streamable
• Linear Correlation (3 %) 
• Correlation Filter (3 %) 
• Joiner (3 %) 
• Column Rename (3 %) Streamable
• Unpivoting (3 %) 
• Extract Table Spec (3 %) 
• CSV Writer (2 %) Streamable
• Database Writer (legacy) (2 %) Streamable
• Simple Regression Tree Predictor (2 %) Streamable
• Create Bit Vector (2 %) 
• Column Aggregator (2 %) Streamable
• Column Appender (2 %) Streamable
• Extract Column Header (2 %) 
• Table Validator (Reference) (2 %) 
• Row Filter (2 %) Streamable
• Reference Row Filter (2 %) 
• Statistics (2 %) 
• Excel Writer (XLS) (2 %) 
• String to Date&Time (2 %) Streamable
• Create Collection Column (< 1 %) Streamable
• Table Writer (< 1 %) 
• Decision Tree Learner (< 1 %) 
• Regression Predictor (< 1 %) 
• Random Forest Learner (Regression) (< 1 %) 
• Concatenate (< 1 %) Streamable
• Auto-Binner (< 1 %) 
• String To Number (< 1 %) StreamableDeprecated
• Column Rename (Regex) (< 1 %) Streamable
• Column Filter (< 1 %) 
• Reference Column Filter (< 1 %) Streamable
• Filter Apply (< 1 %) Streamable
• Missing Value (Apply) (< 1 %) 
• Missing Value (< 1 %) 
• Regex Split (< 1 %) Streamable
• Shuffle (< 1 %) 
• Sorter (< 1 %) 
• String Replacer (< 1 %) Streamable
• Transpose (< 1 %) 
• Value Counter (< 1 %) 
• Numeric Outliers (< 1 %) 
• IF Switch (< 1 %) 
• Line Plot (local) (< 1 %) 
• Parallel Coordinates Plot (JavaScript) (< 1 %) 
• Math Formula (< 1 %) Streamable
• Math Formula (Multi Column) (< 1 %) Streamable
• Excel Sheet Appender (XLS) (< 1 %) 
• Spark Line Appender (< 1 %) 
• Container Output (Table) (< 1 %) 
• Show all 53 recommendations

Workflows

• Four_​Techniques_​Outlier_​Detection
• 01_​Guided_​Analytics_​for_​ML_​Automation
• TSNE on MNIST data
• Dimensionality Reduction
• Santander customer satisfaction using decision tree
• Rossmann - DB - Time Series(2)
• Show all 6 workflows

Installation

To use this node in KNIME, install KNIME Core from the following update site:

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.