Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/26/2024 06:12 AM
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?
06/27/2024 11:38 AM
Provide screenshot of configs
06/27/2024 09:10 PM - last edited on 06/27/2024 10:50 PM by Sunil
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]
06/28/2024 08:41 PM
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"
}
}