Skip to main content

DB_Column.fill_nothing

fill_nothingdefault

Group: Values
Aliases: fill missing, if_nothing

Documentation

Returns a new column where missing values have been replaced with the provided default.

Arguments

  • default: The value to replace missing values with. If this argument is a column, the value from default at the corresponding position will be used. If this argument is Previous_Value, the missing values will be replaced with the previous value in the column. Note that the first rows may stay Nothing if they do not have a previous value to use.

Examples

Fill missing values in a column with the value 20.5.

      import Standard.Examples

example_fill_nothing = Examples.decimal_column.fill_nothing 20.5