# How can i combine the information of two indexes with kibana lens?

**URL:** <https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242>\
**Category:** Kibana\
**Created:** [July 9, 2021, 6:51am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242 "2021-07-09T06:51:56Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![alprde](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alprde/32/90774_2.png) [@alprde](https://discuss.elastic.co/u/alprde)\
**Post date:** [July 9, 2021, 6:51am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/1 "2021-07-09T06:51:56Z")

</div>

I have two indexes named market place and stalls. How many stalls in which market place? How can I show this with kibana lens?

marketplace fields:

- id
- name

stalls fields:

- id
- stall\_no
- marketplace\_id

---

<div class="post-metadata">

**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\
**Post date:** [July 9, 2021, 7:00am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/2 "2021-07-09T07:00:14Z")

</div>

The only way is to join them before ingest to elasticsearch  
That should not be a big deal check what is an enrichment policy in elasticsearch to do that...

---

<div class="post-metadata">

**Author:** ![alprde](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alprde/32/90774_2.png) [@alprde](https://discuss.elastic.co/u/alprde)\
**Post date:** [July 9, 2021, 7:35am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/3 "2021-07-09T07:35:24Z")

</div>

Thank you for the answer. I am importing the data with logstash. Then do I need to merge and add the mysql tables?

---

<div class="post-metadata">

**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\
**Post date:** [July 9, 2021, 7:41am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/4 "2021-07-09T07:41:22Z")

</div>

In that case change your sql query to join all needed tables in one query

---

<div class="post-metadata">

**Author:** ![alprde](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alprde/32/90774_2.png) [@alprde](https://discuss.elastic.co/u/alprde)\
**Post date:** [July 9, 2021, 8:10am UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/5 "2021-07-09T08:10:39Z")

</div>

Is there a simpler way to do this? Because I have to restart logstash on every new query. logstash is running on docker.

---

<div class="post-metadata">

**Author:** ![ghudgins](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ghudgins/32/138532_2.png) [@ghudgins](https://discuss.elastic.co/u/ghudgins)\
**Post date:** [July 13, 2021, 12:30pm UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/6 "2021-07-13T12:30:49Z")

</div>

If you're visualizing the field that "joins" the 2 indexes together ("marketplace\_id" / "id" in your case) then using multiple layers allows you to logically join them around a similar ID

```auto
POST stores/_doc
{
  "id": 1,
  "name": "marketplace1"
}

POST stalls/_doc
{
  "id": 100,
  "store_id": 1,
  "name": "stall 1 in marketplace1"
}

```

Not sure if that works for you or not as you'd have to visualize the ID....

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

---

<div class="post-metadata">

**Author:** ![alprde](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alprde/32/90774_2.png) [@alprde](https://discuss.elastic.co/u/alprde)\
**Post date:** [July 13, 2021, 1:57pm UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/7 "2021-07-13T13:57:47Z")

</div>

Thanks for your answer, but this is not working for me. I will try to insert merge data with mysql.

---

<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:** [August 10, 2021, 1:58pm UTC](https://discuss.elastic.co/t/how-can-i-combine-the-information-of-two-indexes-with-kibana-lens/278242/8 "2021-08-10T13:58:40Z")

</div>

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