# Combining data from two indexes with common field (ID)
**URL:** https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187
**Category:** Elasticsearch
**Created:** [May 28, 2019, 8:25pm UTC](https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187 "2019-05-28T20:25:14Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@saif3r](https://discuss.elastic.co/u/saif3r)
#### Post date: [May 28, 2019, 8:25pm UTC](https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187/1 "2019-05-28T20:25:14Z")
Hello All,
I have two different indexes, one contains a list of items, along with their ID, something like:
**Items:**
> **itemID: int**
> itemName: text
> itemDescription: text
Second index contains orders with a reference to that item and looks like this:
**Orders:**
> orderID: int
> orderPrice: float
> **ItemID: int**
I would like to create an index or a visualization that will combine information from both indexes, the result would look like this:
**Orders Detailed:**
> orderID: int
> orderPrice: float
> ItemID: int
> itemName: text
> itemDescription: text
The source data is pulled using logstash. The source of **Items** is a flat file and is a sort of a dictionary updated few times a day. **Orders** is a transactional data pulled by jdbc every minute.
Is that something that can be achieved using Elasticsearch?
---
### Author:  [@spinscale](https://discuss.elastic.co/u/spinscale)
#### Post date: [May 29, 2019, 7:27am UTC](https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187/2 "2019-05-29T07:27:04Z")
Hey,
joining two indices at query time is not supported. However what about joining these two data structures at index time, so that it is simple to query them? You could embed the ordered items in the order, this way everything is just a query away.
--Alex
---
### Author:  [@saif3r](https://discuss.elastic.co/u/saif3r)
#### Post date: [May 29, 2019, 8:24am UTC](https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187/3 "2019-05-29T08:24:47Z")
Hello @spinscale,
Thank you for the answer. I'm not sure how i could join two structured at index time. Could you shed some more light on that topic or point where I could find more information about this approach so that I could study it? I'd appreciate that.
Thanks!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 26, 2019, 8:24am UTC](https://discuss.elastic.co/t/combining-data-from-two-indexes-with-common-field-id/183187/4 "2019-06-26T08:24:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.