# Merging of indices
**URL:** https://discuss.elastic.co/t/merging-of-indices/116958
**Category:** Elasticsearch
**Created:** [January 25, 2018, 3:59am UTC](https://discuss.elastic.co/t/merging-of-indices/116958 "2018-01-25T03:59:25Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@aneesh](https://discuss.elastic.co/u/aneesh)
#### Post date: [January 25, 2018, 3:59am UTC](https://discuss.elastic.co/t/merging-of-indices/116958/1 "2018-01-25T03:59:25Z")
Hi
```
Student
=======
{
"StudentId":1,
"StudentName":"abc"
}
Subject
=======
{
"SubjectId":101,
"SubjectName":"English"
},
{
"SubjectId":102,
"SubjectName":"Science"
}
SubjectAssigned
===============
{
"SubjectId":101,
"StudentId":1
},
{
"SubjectId":102,
"StudentId":1
}
Student+SubjectAssigned (Need something like this as result)
=======================
{
"StudentId":1,
"StudentName":"abc"
"Subjects":[
{
"SubjectId":101,
"SubjectName":"English"
},
{
"SubjectId":102,
"SubjectName":"Science"
}
]
}
```
Please suggest some solution to do this.
Thanks
Aneesh L
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 25, 2018, 9:24am UTC](https://discuss.elastic.co/t/merging-of-indices/116958/2 "2018-01-25T09:24:24Z")
This is a duplicate of [Merge data fer two indices with foreign key](https://discuss.elastic.co/t/merge-data-fer-two-indices-with-foreign-key/116863/3). Please keep the discussion there.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 25, 2018, 9:24am UTC](https://discuss.elastic.co/t/merging-of-indices/116958/3 "2018-01-25T09:24:32Z")