0 ×

Missing Value

DeprecatedKNIME Base Nodes version 4.4.0.v202106241539 by KNIME AG, Zurich, Switzerland

This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled "Default") provides default handling options for all columns of a given type (i.e. Double, String, Integer, and all other unknown column types). These settings apply to all columns in the input table that are not explicitly mentioned in the second tab, labeled "Individual". This second tab permits individual settings for each available column (thus, overriding the default). To make use of this second approach, select a column or a list of columns (with the same type) which needs extra handling, click "Add", and set the parameters. Click on the label with the column name(s), will select all covered columns in the column list. To remove this extra handling (and instead use the default handling), click the "Remove" button for this column. The possible options are summarized below:


Do Nothing
The missing values are retained, i.e. those missing cells are not touched and will occur - as they are - in the output table. This option is available for all column types.
Remove Row
Any row that contains a missing value for this type, will be completely removed and will not be contained in the output table. This option is available for all column types.
Min, Max, or Mean
Missing values are replaced by either min, max, or the mean value in this column. This option is only available for numeric column types, i.e. Double or Integer. The Mean for integer columns is rounded.
Most Frequent
This option is available for string and integer columns and replaces any occurrence of a missing value with the most frequent value in a column. If two (or more) different values occur equally often, the first value being encountered is used. If a column contains only missing values, the column stays untouched (containing only missing values in the output table).
Fix Value
Replaces the missing values with a static value set by the user. This option is available for Double, Integer, and String columns.

Input Ports

Table potentially containing missing values.

Output Ports

Table where missing values have been handled.

Best Friends (Incoming)



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


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.