I have two different indexes, one contains a list of items, along with their ID, something like:
Second index contains orders with a reference to that item and looks like this:
I would like to create an index or a visualization that will combine information from both indexes, the result would look like this:
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?