# Error in array query

**URL:** <https://community.influxdata.com/t/error-in-array-query/34012>\
**Category:** Systems\
**Created:** [April 22, 2024, 9:35am UTC](https://community.influxdata.com/t/error-in-array-query/34012 "2024-04-22T09:35:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AVVS\_Sudheer](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/avvs_sudheer/32/13075_2.png) [@AVVS\_Sudheer](https://community.influxdata.com/u/AVVS_Sudheer)\
**Post date:** [April 22, 2024, 9:35am UTC](https://community.influxdata.com/t/error-in-array-query/34012/1 "2024-04-22T09:35:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [April 22, 2024, 3:48pm UTC](https://community.influxdata.com/t/error-in-array-query/34012/2 "2024-04-22T15:48:46Z")

</div>

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”)

```auto
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/
```
