# How to find common entries from two indices using Kibana

**URL:** <https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370>\
**Category:** Kibana\
**Created:** [October 19, 2016, 10:19am UTC](https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370 "2016-10-19T10:19:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\
**Post date:** [October 19, 2016, 10:19am UTC](https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370/1 "2016-10-19T10:19:35Z")

</div>

Hi,

I have two indices like "indexA" and "indexB". There is a field "linkdata" in these indices, which is a string, which acts as a foreign key to link between these two indices. Not always it acts as a foreign key, but sometimes, the entry in both indices will be same. I want to identify those data (linkdata strings), which is common to both indices. How can I do this in Kibana?

Thank you.

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [October 19, 2016, 8:10pm UTC](https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370/2 "2016-10-19T20:10:27Z")

</div>

I'm pretty sure it will be difficult to accomplish what you're trying to, as Elasticsearch isn't really set up to have separate indices with foreign keys. But what exactly are you trying to accomplish? Are you trying to get a list of results with each row corresponding to the results of both linked documents? Or are you trying to create some sort of visualization with the linked data?

---

<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:** [October 19, 2016, 8:54pm UTC](https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370/3 "2016-10-19T20:54:48Z")

</div>

This is a join, you cannot do that in ES.

---

<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:** [July 6, 2017, 1:36pm UTC](https://discuss.elastic.co/t/how-to-find-common-entries-from-two-indices-using-kibana/63370/4 "2017-07-06T13:36:13Z")

</div>


