How to Merge couple of JOSN with respect to one provided field value

Hi ,

Please find my input of both Json:

  1. <  
    

[{"tan":"00000000000001","features":[{"gender":"V","age_range":"68+","province":"Flevoland","household_size":"3","household_income":"-","car_ownership":"1 auto","number_children":"Geen registratie kind","urbanity":"Unknown","oldest_child":"Unknown","marital_status":"Unknown","education":"Unknown","work_situation":"Unknown","home_ownership":"Unknown"}]},
{"tan":"00000000000002","features":[{"gender":"V","age_range":"35-54","province":"Friesland","household_size":"3","household_income":"-","car_ownership":"-","number_children":"1 kind","urbanity":"Unknown","oldest_child":"Unknown","marital_status":"Unknown","education":"Unknown","work_situation":"Unknown","home_ownership":"Unknown"}]}]

2.< [

{"tan":"00000000000001","stb_macs":[{"name":"00000001MAC1"},{"name":"00000001MAC2"}]},

{"tan":"00000000000002","stb_macs":[{"name":"00000002MAC1"},{"name":"00000002MAC2"}]}]

I need to process both Json file via logsstash and if "tan" is matching then I will merge the file and store in success index and if tan is not matching in either place then it should move to unsuccess index.

Could someone help me on this to acheive!! with descriptive steps as I am learning logsstash fresh.

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