Documentation

experimental.first() function

experimental.first() is subject to change at any time.

experimental.first() returns the first record with a non-null value in the _value column for each input table.

experimental.first() drops empty tables.

Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]
For more information, see Function type signatures.

Parameters

tables

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

Examples

Return the first non-null value in each input table

import "experimental"
import "sampledata"

sampledata.int(includeNull: true)
    |> experimental.first()

View example input and ouput


Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.