Elastic Search Query - Join Indices

[AnkitaBamania]

Hello Team,

I am working on Data Query under Analytics. I have created two analytics report which is assigned as indices in elastic query report. There is one field from both the indices based on which I want to perform comparison and based on that the data should display from both the indices. Basically, I want to join two indices based on that field.

Can anyone help me with that?

[rushikeshvartak]

Provide screenshot of configs

[AnkitaBamania]

Hi @rushikeshvartak ,

Below are the screenshots:

Elastic query configuration- 

Indices subquery1Test -

Indices Subquery3Test:

We need to join Entitlementvaluekey from 1st index with funt_ent from second index.

Thanks,

Ankita Bamania

[This message has been edited by moderator to mask sensitive information]

[rushikeshvartak]

Sample

{
"source": {
"index": ["index1", "index2"]
},
"pivot": {
"group_by": {
"common_field": { "terms": { "field": "common_field" } }
},
"aggregations": {
"index1_data": { "top_hits": { "_source": ["field1", "field2"] } },
"index2_data": { "top_hits": { "_source": ["field3", "field4"] } }
}
},
"dest": {
"index": "joined_index"
}
}