How to compare data on two different index bassed on common field and update into 3 index

Elastic Stack Kibana
1

I have 3 indexes at elastic. want to compare the 2 index bassed on the common fields and update the data on 3 index.

  1. index A { name field type keyword,phoneno}.
  2. index B { name field type keyword,address}.
  3. Index C has the address and phone no field to update.

index A and B has the common field "name". So based on the name field want to compare and get the "phoneno" and "address" from these indexes and want update this data at index C.

could you please help us to write any script to update the data?

Thank you

2

Hi Surinder,

You can have a look on Enrich processor. The enrich processor adds new data to incoming documents and requires a few special components:

3

HI Ashish,

Enrich Processor we can use for the coming data. but i have the existing data which i want to update.

4

If wanted, you can reindex any already ingested documents using ingest pipeline. It will be one time activity.