Use the Null Replacement transformation to replace NULL values in specified columns with a literal value; the mean, median,or mode of the column; or an imputed value joined from another table. You can request the median value with or without averaging the two middle values when a column has an even number of values.
The available NULL replacement values depend on the data type of the column to transform:
NULL Replacement Value | Allowed Input Table Column Type |
---|---|
Literal | Numeric, character, or date |
Mean | Numeric or date |
Median with averaging | Numeric or date |
Median without averaging | Any supported data type |
Mode | Any supported data type |
Imputed | Any supported data type |