# Merge data from two index in single table

**URL:** <https://discuss.elastic.co/t/merge-data-from-two-index-in-single-table/90628>\
**Category:** Kibana\
**Created:** [June 23, 2017, 11:55am UTC](https://discuss.elastic.co/t/merge-data-from-two-index-in-single-table/90628 "2017-06-23T11:55:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavangovinda](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pavangovinda/32/16640_2.png) [@pavangovinda](https://discuss.elastic.co/u/pavangovinda)\
**Post date:** [June 23, 2017, 11:55am UTC](https://discuss.elastic.co/t/merge-data-from-two-index-in-single-table/90628/1 "2017-06-23T11:55:56Z")

</div>

I have an alias which has 2 indexes. Using Data table to visualize the alias.  
Below are the way i have configured the table.

![](https://us1.discourse-cdn.com/elastic/original/3X/7/2/726ac871f67d243cc3211b0e8e0d1dc34d57fbd5.png) ![](https://us1.discourse-cdn.com/elastic/original/3X/3/9/39d882530dadeb21a9c48ebb61351a584c50c475.png) ![](https://us1.discourse-cdn.com/elastic/original/3X/3/d/3d970cd6031666690643c294732244f08eabafbc.png)

The problem i am facing, the first column "Webservice" is repeated for both the indexes.  
Is there a way i can have only one "Webservice" column followed by two 90th percentile columns.

Here is how it looks currently:

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

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [June 23, 2017, 11:46pm UTC](https://discuss.elastic.co/t/merge-data-from-two-index-in-single-table/90628/2 "2017-06-23T23:46:31Z")

</div>

Are you using an Elasticsearch alias? I am not sure how you would be able to split the table as is seen in your screenshot if that is the case.

Here is the data as I have setup through Console:

```auto
PUT /discuss-90628-a
PUT /discuss-90628-b

POST /_aliases
{
  "actions": [
    {
      "add": {
        "indices": [
          "discuss-90628-a",
          "discuss-90628-b"
        ],
        "alias": "discuss-90628"
      }
    }
  ]
}

POST /discuss-90628-b/doc
{
  "service": "Index",
  "response_time": 1.1
}

POST /discuss-90628-b/doc
{
  "service": "Index",
  "response_time": 1.2
}

POST /discuss-90628-b/doc
{
  "service": "Index",
  "response_time": 1.3
}

POST /discuss-90628-a/doc
{
  "service": "Login",
  "response_time": 2.3
}

POST /discuss-90628-a/doc
{
  "service": "Login",
  "response_time": 2.1
}

POST /discuss-90628-a/doc
{
  "service": "Login",
  "response_time": 2.4
}

```

I now have an index `discuss-90628` which combines data from both `discuss-90628-a` and `discuss-90628-b`. I have intentionally placed those with `service=Login` in one and `service=Index` in the other.

I then created a Data Table of the 90 percentile response times for the services.

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

I also noticed that you're taking the 90th percentile of a field called `90percent`. I am not sure what "90percent" contains, but you probably want to either average it out if it's a sample or perform the aggregation on the actual time.

---

<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 21, 2017, 11:46pm UTC](https://discuss.elastic.co/t/merge-data-from-two-index-in-single-table/90628/3 "2017-07-21T23:46:59Z")

</div>

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