Null Value Replacement Configuration Dialog Box (DB)

Specifies the columns for which to replace the null values. You can replace either null string values or null numeric values.

Setting Description
Defaults: Strings The provided string replaces all null string values in the selected columns. By default, ''.
Defaults: Numerics The provided function replaces all null numeric values in the selected columns. By default, 0.
All/None
  • All selects every column displayed in the list.
  • None clears every selected check box.
Column Name Select the check box for the column name for which to replace null values. Only selected columns are available for null value replacement. When you select a column, the default value of the column's data type is displayed in the Value text box.
Value
  • The string value provided in the text box replaces any null string values in the selected column.
  • The fixed numeric value provided in the text box replaces any null numeric values in the selected column.

If you provide a value of a data type that does not match the column data type, when you click OK, an error is displayed.

Replacing Null DateTime Values

If your selected null value colmn is a datetime data type, it can be compared to any other ISO formatted DateTime value.
Note: ISO provides an international data exchange format framework for DateTime data types that converts all datetime values into the number of milliseconds since 1970. Therefore, the DateTime data can be treated as a numeric column.

Specify the appropriate output data type format for the replacement DateTime value following Joda-Time API formatting. For details, see ISO DateTime Format.

Related reference