# Grouping the Index values by using common field

**URL:** <https://discuss.elastic.co/t/grouping-the-index-values-by-using-common-field/219780>\
**Category:** Elasticsearch\
**Created:** [February 18, 2020, 12:24pm UTC](https://discuss.elastic.co/t/grouping-the-index-values-by-using-common-field/219780 "2020-02-18T12:24:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SanTiaGo\_KarThiCk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/santiago_karthick/32/62188_2.png) [@SanTiaGo\_KarThiCk](https://discuss.elastic.co/u/SanTiaGo_KarThiCk)\
**Post date:** [February 18, 2020, 12:24pm UTC](https://discuss.elastic.co/t/grouping-the-index-values-by-using-common-field/219780/1 "2020-02-18T12:24:01Z")

</div>

Hy guys,

```
     My indexes are =>

                                index1=> eid,name,age
                                index2=>eid,company,address

  Now i am combine these two indexes by creating index as index*

```

but, i need a data table like below,

```
   eid name age company address

   101 rob 22 gu CA
   102 bob 21 hu SA

```

but i am getting is null , i can't set a eid as a primary key and can't group the combined index values.

Help me about this, THANK YOU in Advance 😉

---

<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:** [March 17, 2020, 12:24pm UTC](https://discuss.elastic.co/t/grouping-the-index-values-by-using-common-field/219780/2 "2020-03-17T12:24:07Z")

</div>

Closed on March 17, 2020, 12:24pm UTC

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