Comparison of two different fields in two indexes

Hi All,

We have a scenario where we need to check whether this account number exists in both the indexes , is there a way or query to check the same.

This sounds like a type of join, which Elasticsearch does not support. Doing this through a query at scale in a distributed system would also be quite expensive. You may however be able to create an account centric index using transforms and then query that.

Hi @Christian_Dahlqvist : I have created alias and it is giving desired results