# Is it possible combine two index together in Kibana

**URL:** https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345
**Category:** Kibana
**Created:** [August 25, 2020, 6:48pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345 "2020-08-25T18:48:28Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 6:48pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/1 "2020-08-25T18:48:28Z")

</div>

I have two index data which i am using in kibana.For that I created Visulazation as well and able to see Data in dashboard.

But challange is when i am filtering data for Index1 after clicking on +Button other index data is not appearing,Same thing is happening for Index2 as well.

Is it possible to combine both the index together.

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 7:01pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/2 "2020-08-25T19:01:53Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a399c1230f1f50a0daa29ba9fdd876826f7d77d1.png)

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 7:03pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/3 "2020-08-25T19:03:14Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7de85fd7a5ee2cf15cd845f869a12f1a9c64f0c7.png)

---

<div class="post-metadata">

### Author: ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 25, 2020, 7:31pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/4 "2020-08-25T19:31:28Z")

</div>

Hello @AKumar123

Is the field and value available in both data sets?

Could you show the config for each visualization?

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 7:38pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/5 "2020-08-25T19:38:09Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/6/5/65ef568c67276f75c55ff9fd49f9d8a3994ff079.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3b1246c7393dbcae8e706058dbec48f716f594e5.png)

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 7:40pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/6 "2020-08-25T19:40:25Z")

</div>

Value is same in both the Data Set,But Field name is different.If I make field name same it replaces the values.

I combine both the indexes with index\* also..

---

<div class="post-metadata">

### Author: ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 25, 2020, 7:48pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/7 "2020-08-25T19:48:19Z")

</div>

I'd recommend creating a field alias on one index so that both sets of data can use the same field name - [https://www.elastic.co/guide/en/elasticsearch/reference/master/alias.html](https://www.elastic.co/guide/en/elasticsearch/reference/master/alias.html)

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 25, 2020, 7:51pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/8 "2020-08-25T19:51:12Z")

</div>

can not create one Index becasue other data coming from different system.

---

<div class="post-metadata">

### Author: ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 25, 2020, 8:02pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/9 "2020-08-25T20:02:38Z")

</div>

Then you need to write an OR query that addresses both fields.

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 26, 2020, 9:24am UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/10 "2020-08-26T09:24:09Z")

</div>

what is OR Query how can we achieve in UI Level

---

<div class="post-metadata">

### Author: ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 26, 2020, 11:48am UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/11 "2020-08-26T11:48:28Z")

</div>

Use the search bar - `fieldname: value OR fieldname: value`

---

<div class="post-metadata">

### Author: ![AKumar123](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@AKumar123](https://discuss.elastic.co/u/AKumar123)
#### Post date: [August 26, 2020, 12:06pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/12 "2020-08-26T12:06:34Z")

</div>

search is working fine for both indexes.Filter not working.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fd1bb3b3fbc4d94b03d386f78e34d354848a002d.png)

---

<div class="post-metadata">

### Author: ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 26, 2020, 2:27pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/13 "2020-08-26T14:27:44Z")

</div>

You need to click 'edit query dsl' - this PR has examples - [https://github.com/elastic/kibana/pull/5109#issuecomment-151600967](https://github.com/elastic/kibana/pull/5109#issuecomment-151600967)

---

<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: [September 23, 2020, 2:27pm UTC](https://discuss.elastic.co/t/is-it-possible-combine-two-index-together-in-kibana/246345/14 "2020-09-23T14:27:49Z")

</div>

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