Skip to main content

DB_Table.fill_empty

fill_emptycolumns default

Group: Values
Aliases: fill empty, if_empty

Documentation

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

Arguments

  • columns: Specifies columns by a name, index or regular expression to match names, or a Vector of these.
  • default: The value to replace empty 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 empty values will be replaced with the previous value in the column. Note that the first rows may stay empty if they do not have a previous value to use.

Examples

Fill empty values in two columns with the value "hello".

      fill_empty = table.fill_empty ["col0", "col1"] "hello"