fill() function

fill() replaces all null values in input tables with a non-null value.

Output tables are the same as the input tables with all null values replaced in the specified column.

Function type signature
(<-tables: stream[B], ?column: string, ?usePrevious: bool, ?value: A) => stream[C] where B: Record, C: Record

For more information, see Function type signatures.



Column to replace null values in. Default is _value.


Constant value to replace null values with.

Value type must match the type of the specified column.


Replace null values with the previous non-null value. Default is false.


Input data. Default is piped-forward data (<-).


Fill null values with a specified non-null value

import "sampledata" true)
    |> fill(value: 0)

View example input and output

Fill null values with the previous non-null value

import "sampledata" true)
    |> fill(usePrevious: true)

View example input and output

Was this page helpful?

Thank you for your feedback!

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more