Hi, I need to merge data from two indices (test1 and test2) based on a common key (information). Here’s a simplified example of my indices: Index test1: sample_id information price --------- ------- ---------------- test1 11 52 test2 11 53 test3 …

[image] prashant1: Is there anyway to achieve it using transform I don't think it's made for that use case. [image] prashant1: Is there anyway to achieve it using [...] logstash Yes probably. You would need to create a new index. Like reading the index test1 with an elasticsearch inpu…

Discuss the Elastic Stack

Need Help with Merging Data from Two Elasticsearch Indices

Elastic Stack Elasticsearch

prashant1 July 18, 2024, 12:39pm 3

Thanks @dadoonet for the quick response.

Is there anyway to achieve it using transform or logstash as I have access restrictions to work on the enrich policies ?

Merging the data column wise from two different indexes

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.