# Getting Results Referencing Multiple Indexs at Once

**URL:** https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981
**Category:** Elasticsearch
**Created:** [May 23, 2020, 8:07am UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981 "2020-05-23T08:07:32Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![rukmalf](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rukmalf](https://discuss.elastic.co/u/rukmalf)
#### Post date: [May 23, 2020, 8:07am UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981/1 "2020-05-23T08:07:33Z")

</div>

Hi,

I have 3 CSVs which I use to create 3 indexes. But the problem is the 1st and 3rd Indexes are connected via the 2nd Index (refer to the image)

 ![elastic_1](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9ce9d1eec95ace066d4f386655a01b63f161f7f1.jpeg) .

My final result should be A1, A2, A3,B1,B2,B3. How can I get this thing to work?

BR  
Rukmal

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 23, 2020, 9:09am UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981/2 "2020-05-23T09:09:51Z")

</div>

Elasticsearch does not support joins like a relational database does so you need to reindex your data and create documents the way you want to search and retrieve them, e.g. documents with all fields from the three files.

---

<div class="post-metadata">

### Author: ![rukmalf](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rukmalf](https://discuss.elastic.co/u/rukmalf)
#### Post date: [May 23, 2020, 10:51am UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981/3 "2020-05-23T10:51:03Z")

</div>

Hi Christian,

Thank you for the input. The issue I have is, is there a way to use Logstash to put everything to one index based on the relationships, because I am talking about millions of documents (log lines) in 3 CSVs as shown in the above diagram.

What would be the easiest way to get this working?

BR

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 23, 2020, 1:46pm UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981/4 "2020-05-23T13:46:42Z")

</div>

Yes, you may be able to do this using Logstash, but I would recommend opening a eparate issue under that category.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 20, 2020, 1:46pm UTC](https://discuss.elastic.co/t/getting-results-referencing-multiple-indexs-at-once/233981/5 "2020-06-20T13:46:52Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.