getRecord() function
The getRecord()
function extracts a record from a table given the record’s index.
If the index is out of bounds, the function errors.
Function type: Stream and table
getRecord(idx: 0)
Use tableFind() to extract a single table
getRecord()
requires a single table as input.
Use tableFind()
to extract a single table from a stream of tables.
Parameters
idx
Index of the record to extract.
Data type: Integer
Example
r0 = from(bucket:"example-bucket")
|> range(start: -5m)
|> filter(fn:(r) => r._measurement == "cpu")
|> tableFind(fn: (key) => key._field == "usage_idle")
|> getRecord(idx: 0)
// Use record values
x = r0._field + "--" + r0._measurement
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.