# Merge 2 types based on common field
**URL:** https://discuss.elastic.co/t/merge-2-types-based-on-common-field/16632
**Category:** Elasticsearch
**Created:** [March 27, 2014, 7:09am UTC](https://discuss.elastic.co/t/merge-2-types-based-on-common-field/16632 "2014-03-27T07:09:10Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Fawad\_Shah](https://discuss.elastic.co/u/Fawad_Shah)
#### Post date: [March 27, 2014, 7:09am UTC](https://discuss.elastic.co/t/merge-2-types-based-on-common-field/16632/1 "2014-03-27T07:09:10Z")
Hi,
I have an index named 'product' it has two types named 'type1' and 'type2'
For example:
/{
product\_id: "1111",
price: "23.56",
stock: "100"
}/
/{
product\_id: "1111",
category: "iPhone case",
manufacturer: "Belkin"
}/
I want them to join based on 'product\_id' and index them in either new index
or new type in same 'product' index, so eventually it should look like this.
/{
product\_id: "1111",
price: "23.56",
stock: "100"
category: "iPhone case",
manufacturer: "Belkin"
}/
FYI,
- I have millions of records similar to above, so finally I will be doing
the similar thing for all.
- I am using ELK stack.
- My end goal is to display the combined result of above 2 types in Kibana.
My question is similar to this
[http://elasticsearch-users.115913.n3.nabble.com/Combining-fields-from-various-indexes-td4031116.html](http://elasticsearch-users.115913.n3.nabble.com/Combining-fields-from-various-indexes-td4031116.html)
but the person reported this question have 2 separate indexes while I have
one index but 2 separate types.
Thanks!
--
View this message in context: [http://elasticsearch-users.115913.n3.nabble.com/Merge-2-types-based-on-common-field-tp4052873.html](http://elasticsearch-users.115913.n3.nabble.com/Merge-2-types-based-on-common-field-tp4052873.html)
Sent from the ElasticSearch Users mailing list archive at [Nabble.com](http://Nabble.com).
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/1395904150360-4052873.post%40n3.nabble.com](https://groups.google.com/d/msgid/elasticsearch/1395904150360-4052873.post%40n3.nabble.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:40am UTC](https://discuss.elastic.co/t/merge-2-types-based-on-common-field/16632/2 "2017-07-06T01:40:19Z")