{"title":"Constant Value Column Filter","nodeType":"Manipulator","id":"*j60SFMSkRj-uaDgY","factoryName":"org.knime.base.node.preproc.filter.constvalcol.ConstantValueColumnFilterNodeFactory","factoryId":"org.knime.base.node.preproc.filter.constvalcol.ConstantValueColumnFilterNodeFactory","path":["Manipulation","Column","Filter"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>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.</p>\n        ","shortDescription":"The Constant Value Column Filter filters columns\ncontaining only duplicates of the same value.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Filter"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/AP+gvaeTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAB3RJTUUH4gQTDC0VZJkJ+AAAAGdJREFUOMtjZGBg+M+AGzBCaZxqWBgYGBie+fljSEht2ojC5y99hKHmY7ccAxMDhYCRKl7A5byh4QV08J9UNRR7YRgYwEKC2v9Y2Iz4oomRgCGM2CT/E5Eu/iNrZkST/AcNl//Epg8AYU8fFbe1GK8AAAAASUVORK5CYII=","sinceVersion":"3.6.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table to be filtered","description":"Table from which columns are to be filtered."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Filtered Table","description":"Table excluding filtered columns."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Remove from the selected columns","description":"Choose whether to remove all constant value columns or only those containing a specific value.\n<ul><li><b>all constant value columns</b> : Remove all constant value columns from the columns considered for filtering, independent of the specific value they contain in duplicates.</li><li><b>constant value columns that only contain</b> : Remove only those constant value columns from the columns considered for filtering that only contain a certain specific value.</li></ul>","optional":false},{"name":"numeric values of","description":"Remove only those constant value columns that only contain a certain specific numeric value.","optional":false},{"name":"string values of","description":"Remove only those constant value columns that only contain a certain specific textual value.","optional":false},{"name":"missing values","description":"Remove only those constant value columns that only contain empty cells / missing values.","optional":false},{"name":"Considered columns","description":"This list contains the column names of the input table that are to be considered for filtering.","optional":false},{"name":"Minimum number of rows","description":"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.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*xTIHpIYhQRCNETkp","factoryName":"org.knime.base.node.preproc.filter.missingvaluecolfilter.MissingValueColumnFilterNodeFactory","probability":0.0891089108910891},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.06930693069306931},{"id":"*7isNz6mji9l5c7Iv","factoryName":"org.knime.base.node.preproc.normalize3.Normalizer3NodeFactory","probability":0.0594059405940594},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.039603960396039604},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.0297029702970297},{"id":"*MD6juzhoWJLJGkE9","factoryName":"org.knime.base.node.util.extracttablespec.ExtractTableSpecNodeFactory","probability":0.0297029702970297},{"id":"*NLi-6Jsf1G1obd8x","factoryName":"org.knime.base.node.preproc.correlation.filter.CorrelationFilterNodeFactory","probability":0.0297029702970297},{"id":"*oluxz9j9RhfJY3E0","factoryName":"org.knime.base.node.preproc.correlation.compute.CorrelationComputeNodeFactory","probability":0.0297029702970297},{"id":"*OrsWDmrgrJ2VEX6h","factoryName":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","probability":0.0297029702970297},{"id":"*6CbObXLq9oHq_EFi","factoryName":"org.knime.base.node.preproc.constantvalue.ConstantValueColumnNodeFactory","probability":0.0297029702970297}]}