# Feasibility in joining two indexes in elasticsearch

**URL:** https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577
**Category:** Elasticsearch
**Created:** [September 14, 2020, 7:59pm UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577 "2020-09-14T19:59:06Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 14, 2020, 7:59pm UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/1 "2020-09-14T19:59:06Z")

</div>

Hi All,

I have a index named "dev-ticket" which stores the data of all the incidents created  
and "dev-perf" which stores the data related to respective server performance

Is there are way to join these two index into one and build visualization out of it?

I tried creating a third index "dev\*" it has all the fields created but the values i'm getting is only for "dev-ticket" the other index data is not getting loaded up, is my approach is wrong?

In simple words its a cross index search.

Please advice.

Thanks  
Gautham

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [September 14, 2020, 10:05pm UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/2 "2020-09-14T22:05:36Z")

</div>

There's no way to do that in Kibana.

How did you try to create the merged index exactly?

---

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 15, 2020, 9:40am UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/3 "2020-09-15T09:40:02Z")

</div>

@warkolm As i mentioned both my index are named as **dev-ticekt** and **dev-perf** , so i created a new index as **dev**

Is there any other way to achieve this scenario in ELK, because our main use of ELK is dashboarding, analytics and reporting . without having a correlation of data from different data sources we cannot achieve this.

Thanks  
Gautham

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [September 15, 2020, 8:56pm UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/4 "2020-09-15T20:56:53Z")

</div>

Ok but how did you create the new index? Did you just call the API to create and not put data in there? Or did you reindex? If you reindexed, what was the request?

---

<div class="post-metadata">

### Author: ![Gauti](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [September 16, 2020, 4:14am UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/5 "2020-09-16T04:14:57Z")

</div>

@warkolm i didnt reindex, i just did an alias creation and added those two indexes.

Thanks  
Gautham

---

<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: [October 14, 2020, 4:15am UTC](https://discuss.elastic.co/t/feasibility-in-joining-two-indexes-in-elasticsearch/248577/6 "2020-10-14T04:15:00Z")

</div>

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