Error in array query

1

Hi,
When I try to execute the query in influx

import “array”
import “internal/debug”
from(bucket: “sample1”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Country”)
//|> filter(fn:(r) => r[“state”] ==“HP”)
//|> filter(fn:(r) => r[“City”] ==“ABC”)
//|> filter(fn:(r) => r[“tag”] == “Sales”)
array.from(
rows: [
{City: “ABC”, tag: “Sales”},
{City: “ABC”, tag: debug.null(type: “string”)}
]
)
|> group()
|> yield()

It is showing an error as “tried to produce more than one result with the same _result”

I tried but didn’t resolve. Can anyone help me where the error and help me to fix it

2

Hello @AVVS_Sudheer,
Yes you need a yield() for each result set:
import “array”
import “internal/debug”
from(bucket: “sample1”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Country”)
//|> filter(fn:(r) => r[“state”] ==“HP”)
//|> filter(fn:(r) => r[“City”] ==“ABC”)
//|> filter(fn:(r) => r[“tag”] == “Sales”)
|> yield(name: “queried data”)

// your separate array
array.from(
rows: [
{City: “ABC”, tag: “Sales”},
{City: “ABC”, tag: debug.null(type: “string”)}
]
)
|> group()
|> yield(name: “your other result set”)

If you want to combine these you can use union or join:
https://docs.influxdata.com/flux/v0/stdlib/universe/union/
https://docs.influxdata.com/flux/v0/join-data/