Missing Value

This node helps handle missing values found in cells of the input table.

The first section "Treatment by Column" permits individual settings for each available column. Only columns that are not listed here are treated according to the settings in the second section "Treatment by Data Type". It is possible to select more than one column within one element leaving only treatment options that are applicable to all selected columns enabled.

The second section "Treatment by Data Type" provides default handling options for all columns of a given type. These settings apply to all columns in the input table that are not explicitly mentioned in the first section "Treatment by Column".

Treatment options marked with an asterisk (*) will result in non-standard PMML, which uses extensions that cannot be read by other tools than KNIME.

Input ports

1. Type: Table
   Input table
   Table with missing values.

Output ports

1. Type: Table
   Output table
   Table with replaced missing values.
2. Type: PMML
   PMML Transformations
   Table with PMML documenting the missing value replacement.