docs-v2/content/flux/v0.x/stdlib/array/from.md

title	description	aliases	menu	weight	flux/v0.x/tags	introduced
array.from() function	The experimental `array.from()` function constructs a table from an array of records.	/influxdb/v2.0/reference/flux/stdlib/array/from/ /influxdb/cloud/reference/flux/stdlib/array/from/ /influxdb/v2.0/reference/flux/stdlib/experimental/array/from/ /influxdb/cloud/reference/flux/stdlib/experimental/array/from/ /flux/v0.x/stdlib/experimental/array/from/	flux_0_x_ref name parent array.from array	401	inputs	0.103.0

The array.from() function constructs a table from an array of records. Each record in the array is converted into an output row or record. All records must have the same keys and data types.

{{< keep-url >}}

import "array"

array.from(
    rows: [
        {_time: 2020-01-01T00:00:00Z, _field: "exampleField", _value: 3, foo: "bar"},
        {_time: 2020-01-01T00:01:00Z, _field: "exampleField", _value: 4, foo: "bar"},
        {_time: 2020-01-01T00:02:00Z, _field: "exampleField", _value: 1, foo: "bar"},
    ],
)

Parameters

rows

Array of records to construct a table with.

Examples

Build an arbitrary table

import "array"

rows = [{foo: "bar", baz: 21.2}, {foo: "bar", baz: 23.8}]

array.from(rows: rows)

Union custom rows with query results

import "influxdata/influxdb/v1"
import "array"

tags = v1.tagValues(bucket: "example-bucket", tag: "host")
wildcard_tag = array.from(rows: [{_value: "*"}])

union(tables: [tags, wildcard_tag])