# Fetch additional info for each Elasticsearch
**URL:** https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880
**Category:** Elasticsearch
**Created:** [October 16, 2021, 1:07am UTC](https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880 "2021-10-16T01:07:18Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@pedrorabbi](https://discuss.elastic.co/u/pedrorabbi)
#### Post date: [October 16, 2021, 1:07am UTC](https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880/1 "2021-10-16T01:07:18Z")
So, I have 2 indexes in my Elasticsearch server. I need to gather the results from the first index, and for each result I need to gather info from the second index.
How to do that? Tried the foreach processor, but no luck so far.
Tky
---
### Author:  [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [October 16, 2021, 2:48am UTC](https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880/2 "2021-10-16T02:48:15Z")
you can use logstash
input = first index read what you need
filter = Elasticsearch
[https://www.elastic.co/guide/en/logstash/current/plugins-filters-elasticsearch.html](https://www.elastic.co/guide/en/logstash/current/plugins-filters-elasticsearch.html)
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [October 16, 2021, 3:31am UTC](https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880/3 "2021-10-16T03:31:12Z")
What you are describing sounds like a join, which Elasticsearch does not support at query time. I would recommend instead denormalizing the data set and joining the two indices.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 13, 2021, 3:31am UTC](https://discuss.elastic.co/t/fetch-additional-info-for-each-elasticsearch/286880/4 "2021-11-13T03:31:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.