How to compare two fields of two or more documents


I have 500 documents and half of them contains "IP.keyword" and half contains "Pim_IP".keyword. Now I want to filter to get all the document which will have Pim_IP(from one docuement) == IP.keyword( from other document). How to achieve this please help.

Any assistance on this will help me a lot.

You can't do this in Kibana, because it would require two sequential requests to construct this type of query. Kibana only uses parallel requests.

Because you can do this with two sequential requests, you can automate it using some kind of tool that is external to ES and Kibana, and then send the results back to Elasticsearch to visualize in Kibana.

edit: we are tracking requests like this for multi-step requests in Kibana, and will use this feedback as an example of one of the things that users are asking for while prioritizing work.


Yeah please If this kind of functionality can be added in kibana then It would be really great for the users.

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