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 |