Documentation

Work with arrays

An array type is an ordered sequence of values of the same type.

Array syntax

An array literal contains a sequence of values (also known as elements) enclosed in square brackets ([]). Values are comma-separated and must be the same type.

Example arrays
["1st", "2nd", "3rd"]

[1.23, 4.56, 7.89]

[10, 25, -15]

Reference values in an array

Use bracket notation to reference reference a value in an array. Flux arrays use zero-based indexing. Provide the index of the value to reference.

arr = ["1st", "2nd", "3rd"]

arr[0]
// Returns 1st

arr[2]
// Returns 3rd

Operate on arrays

Iterate over an array

Flux currently does not provide a way to iterate over an array.

Check if a value exists in an array

Use the contains function to check if a value exists in an array.

names = ["John", "Jane", "Joe", "Sam"]

contains(value: "Joe", set: names)
// Returns true

Get the length of an array

Use the length function to get the length of an array (number of elements in the array).

names = ["John", "Jane", "Joe", "Sam"]

length(arr: names)
// Returns 4

Create a stream of tables from an array

  1. Import the array package.
  2. Use array.from() to return a stream of tables. The input array must be an array of records. Each key-value pair in the record represents a column and its value.
import "array"

arr = [
  {fname: "John", lname: "Doe", age: "37"},
  {fname: "Jane", lname: "Doe", age: "32"},
  {fname: "Jack", lname: "Smith", age: "56"}
]

array.from(rows: arr)
Output
fnamelnameage
JohnDoe37
JaneDoe32
JackSmith56

Compare arrays

Use the == comparison operator to check if two arrays are equal. Equality is based on values, their type, and order.

[1,2,3,4] == [1,3,2,4]
// Returns false

[12300.0, 34500.0] == [float(v: "1.23e+04"), float(v: "3.45e+04")]
// Returns true

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.