Replace Nulls

Description

A null value means the corresponding value is missing, unknown, or inapplicable.

Removes nulls from the values of the column you apply this operation to. You have the option of replacing null values with one or more characters.

When you apply this operation, Prep Data first asks you to enter the characters you wish to replace nulls with:

 

INPUT/Output DATA TYPE

Input	Output
text, date/time, numeric	text, date/time, numeric

 

Note that the replacement text should be of the same type as the original data type of the field.

example

In this example, the original column is Zip. The Replace Null Values operation was used to remove the null values and replace with 0 to produce the resulting values in Zip**.