Work with null types

The null type represents a missing or unknown value.

Type name: null

• Null syntax
• Check if a column value is null
• Include null values in an ad hoc stream of tables

Null syntax

Null types exist in columns of other basic types. Flux does not provide a literal syntax for a null value, however, you can use debug.null() to return a null value of a specified type.

import "internal/debug"

// Return a null string
debug.null(type: "string")

// Return a null integer
debug.null(type: "int")

// Return a null boolean
debug.null(type: "bool")

Check if a column value is null

In functions that iterate over rows (such as filter() or map()), use the exists logical operator to check if a column value is null.

Filter out rows with null values

data
    |> filter(fn: (r) => exists r._value)

Include null values in an ad hoc stream of tables

1. Use array.from() to create an ad hoc stream of tables.
2. Use debug.null() to include null column values.

import "array"
import "internal/debug"

array.from(
    rows: [
        {a: 1, b: 2, c: 3, d: "four"},
        {a: debug.null(type: "int"), b: 5, c: 6, d: debug.null(type: "string")}
    ]
)

The example above returns: