# Compare two indexes different field value

**URL:** <https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303>\
**Category:** Elasticsearch\
**Created:** [August 3, 2022, 12:05pm UTC](https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303 "2022-08-03T12:05:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alex\_vermex](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_vermex/32/101267_2.png) [@alex\_vermex](https://discuss.elastic.co/u/alex_vermex)\
**Post date:** [August 3, 2022, 12:05pm UTC](https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303/1 "2022-08-03T12:05:44Z")

</div>

Hi,  
i would like to know if it is possible to compare field.value with different indexes i mean for example i have index1 and index2 and each index has fields so i want to compare field value of index1 with field value on index2 I don't know if it's possible 😕

Any help would be sincerely appreciate!  
Thanks!

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [August 4, 2022, 5:53am UTC](https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303/2 "2022-08-04T05:53:14Z")

</div>

That sounds a lot like a join, which Elasticsearch does not support. It may help if you provide some additional information around the high level problem you are looking to solve so someone here may be able to suggest alternate approaches.

---

<div class="post-metadata">

**Author:** ![79g](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/79g/32/109191_2.png) [@79g](https://discuss.elastic.co/u/79g)\
**Post date:** [August 4, 2022, 8:40am UTC](https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303/3 "2022-08-04T08:40:11Z")

</div>

Hello!

without more details about your problem I would say that your problem is related with **denormalization**. It is a technique used to improve the queries (performance and response time) by adding some redundant data. It means that **probably you should have your two indices merged in one**.

If that is not an option for you, you could do a manual _join_ with your client... but not recommended.

It would help if you provide more details about your problem, context...

Hope it helps!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 1, 2022, 8:40am UTC](https://discuss.elastic.co/t/compare-two-indexes-different-field-value/311303/4 "2022-09-01T08:40:57Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.