How to join 2 index using 2 common values

[Hendrik_Muhs]

With transform you can query 2 or more indices and if they have a common field, like an id, you can "join" the results by grouping the common id.

To combine the documents you can use a scripted metric aggregation. It's possible to "collapse" the other documents, which means creating an array of all source documents, or you "join" them, meaning one overwrite the other one. For the later you have to decide the order.

Example post:

Combine multiple document into one document with limited Fields ( merging of documents )

You can use a transform for it. The group_by must be based on a common criteria, e.g. a common id. For the combining step, you can use a scripted metric, e.g.: "all_docs": { "scripted_metric": { "init_script": "state.docs = []", "map_script": "state.docs.add(new HashMap(params['_source']))", "combine_script": "return state.docs", "reduce_script": "def docs = []; for (s in states) {for (d in s) { docs.add(d);}}return docs" } } this would create an array with the original do…