Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/flux/v0.x/stdlib/universe/fill.md

3.9 KiB
Raw Permalink Blame History

title description aliases menu weight flux/v0.x/tags related introduced
fill() function The `fill()` function replaces all null values in an input stream and replace them with a non-null value.
/influxdb/v2.0/reference/flux/functions/transformations/fill
/influxdb/v2.0/reference/flux/functions/built-in/transformations/fill/
/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/fill/
/influxdb/cloud/reference/flux/stdlib/built-in/transformations/fill/
flux_0_x_ref
name parent
fill universe
102
transformations
/{{< latest "influxdb" >}}/query-data/flux/fill/
/{{< latest "influxdb" "v1" >}}/query_language/explore-data/#group-by-time-intervals-and-fill, InfluxQL – FILL
0.14.0

The fill() function replaces all null values in an input stream with a non-null value. The output stream is the same as the input stream with all null values replaced in the specified column.

fill(column: "_value", value: 0.0)

// OR

fill(column: "_value", usePrevious: true)

Parameters

column

The column in which to replace null values. Defaults to "_value".

value

The constant value to use in place of nulls. The value type must match the value type of the column.

usePrevious

When true, assigns the value set in the previous non-null row.

{{% note %}} Cannot be used with value. {{% /note %}}

tables

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

Examples

{{% flux/sample-example-intro plural=true %}}

Fill null values with a specified non-null value

import "sampledata"

sampledata.float(includeNull: true)
    |> fill(value: 0.0)

{{< expand-wrapper >}} {{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "float" true %}}

{{% /flex-content %}} {{% flex-content %}}

Output data
_time tag _value
2021-01-01T00:00:00Z t1 -2.18
2021-01-01T00:00:10Z t1 0.0
2021-01-01T00:00:20Z t1 7.35
2021-01-01T00:00:30Z t1 0.0
2021-01-01T00:00:40Z t1 0.0
2021-01-01T00:00:50Z t1 4.43
_time tag _value
2021-01-01T00:00:00Z t2 0.0
2021-01-01T00:00:10Z t2 4.97
2021-01-01T00:00:20Z t2 -3.75
2021-01-01T00:00:30Z t2 19.77
2021-01-01T00:00:40Z t2 0.0
2021-01-01T00:00:50Z t2 1.86

{{% /flex-content %}} {{< /flex >}} {{% /expand %}} {{< /expand-wrapper >}}

Fill null values with the previous non-null value

import "sampledata"

sampledata.float(includeNull: true)
    |> fill(usePrevious: true)

{{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "float" true %}}

{{% /flex-content %}} {{% flex-content %}}

Output data
_time tag _value
2021-01-01T00:00:00Z t1 -2.18
2021-01-01T00:00:10Z t1 -2.18
2021-01-01T00:00:20Z t1 7.35
2021-01-01T00:00:30Z t1 7.35
2021-01-01T00:00:40Z t1 7.35
2021-01-01T00:00:50Z t1 4.43
_time tag _value
2021-01-01T00:00:00Z t2
2021-01-01T00:00:10Z t2 4.97
2021-01-01T00:00:20Z t2 -3.75
2021-01-01T00:00:30Z t2 19.77
2021-01-01T00:00:40Z t2 19.77
2021-01-01T00:00:50Z t2 1.86

{{% /flex-content %}} {{< /flex >}} {{% /expand %}}