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.
Parameters
column
Column to replace null values in. Default is _value.
value
Constant value to replace null values with.
Value type must match the type of the specified column.
usePrevious
Replace null values with the previous non-null value.
Default is false.
tables
Input data. Default is piped-forward data (<-).
Examples
Fill null values with a specified non-null value
import "sampledata"
sampledata.int(includeNull: true)
|> fill(value: 0)
Fill null values with the previous non-null value
import "sampledata"
sampledata.int(includeNull: true)
|> 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:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.