# String Matching between two kibana indexes

**URL:** <https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847>\
**Category:** Kibana\
**Created:** [January 3, 2019, 4:23pm UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847 "2019-01-03T16:23:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![gauravb](https://avatars.discourse-cdn.com/v4/letter/g/34f0e0/32.png) [@gauravb](https://discuss.elastic.co/u/gauravb)\
**Post date:** [January 3, 2019, 4:23pm UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/1 "2019-01-03T16:23:05Z")

</div>

I have two different indexes in kibana and both have a common ID say **CASE\_ID**. I want to see how many CASE ID from **index 1** matches with CASE ID in **index 2**

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 4, 2019, 6:39pm UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/2 "2019-01-04T18:39:04Z")

</div>

Based on the limited information in your post, I don't think this is possible. But maybe if I can understand your situation in more detail I can help come up with a solution. Can you share an example of the documents in each index? How are the indexes named?

---

<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:** [January 4, 2019, 8:50pm UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/3 "2019-01-04T20:50:50Z")

</div>

This is a join, which Elasticsearch and Kibana cannot do.  
You would need to run two queries, one to grab all the id's from the first index, and then query them in the second index.

---

<div class="post-metadata">

**Author:** ![gauravb](https://avatars.discourse-cdn.com/v4/letter/g/34f0e0/32.png) [@gauravb](https://discuss.elastic.co/u/gauravb)\
**Post date:** [January 10, 2019, 10:37am UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/4 "2019-01-10T10:37:28Z")

</div>

@mark Yes mark- you got it correct . I thing what you'r suggesting might work. Can you please tell me how to do that ?  
@Nick - Thanx nick

---

<div class="post-metadata">

**Author:** ![gauravb](https://avatars.discourse-cdn.com/v4/letter/g/34f0e0/32.png) [@gauravb](https://discuss.elastic.co/u/gauravb)\
**Post date:** [January 14, 2019, 4:28am UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/5 "2019-01-14T04:28:49Z")

</div>

@mark Yes mark- you got it correct . I thing what you'r suggesting might work. Can you please tell me how to do that ?  
@Nick - Thanx nick

---

<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:** [February 11, 2019, 4:28am UTC](https://discuss.elastic.co/t/string-matching-between-two-kibana-indexes/162847/6 "2019-02-11T04:28:51Z")

</div>

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