experimental.fill() function
experimental.fill() is subject to change at any time.
experimental.fill() replaces all null values in the _value column with a non-null value.
Function type signature
(<-tables: stream[{B with _value: A}], ?usePrevious: bool, ?value: A) => stream[{B with _value: A}]
For more information, see Function type signatures.
Parameters
value
Value to replace null values with.
Data type must match the type of the _value column.
usePrevious
Replace null values with the value of the previous non-null row.
tables
Input data. Default is piped-forward data (<-).
Examples
Fill null values with a specified non-null value
import "experimental"
import "sampledata"
sampledata.int(includeNull: true)
|> experimental.fill(value: 0)
Fill null values with the previous non-null value
import "experimental"
import "sampledata"
sampledata.int(includeNull: true)
|> experimental.fill(usePrevious: true)
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.