How to find duplicate numbers in multiple fields?

[gabriel_tessier]

Hi,

Found this solution that can also help depend on your needs and data:

How to merge two indexes based on common field in Elasticsearch?

You could use the scroll api to do a single search across both indices sorted by customer-Id. That would give you a single stream of results with related docs next to each other in the results order. A custom script could consume this stream and merge the doc pairs and then add the merged doc to a new index using the bulk api

if you merge your 2 indices in one and remove the duplicate, you can use this third index to populate your report.