Merging JSON files

[NPNP (NP)]

Hello everyone,

100% newbie here. Thank you for your patience.

I'm trying to merge two simple json files under certain condition. Is that possible? Any direction is useful.

JSON_1

{
    "name_1" : "John",
    "age_1": 25
}

JSON_2

{
    "name_2" : "John",
    "company" : "xyz"
}

So, if "name_1" is equal to "name_2", I would like to merge JSON files and change "name_1" and "name_2" to just "name". Output would be:

{
     "name": "John",
     "age_1": 25,
     "company" : "xyz"
}

Merging JSONs with JavaScript is easy, but I would like to do it with Elastisearch too.

Any help is appreciated. Thank you very much.

[NPNP (NP)]

I just found this question answered. I'm trying to figure out if I can combine fields in Kibana.

How to combine two file types in logstash

I have two different file types as below file { path => "/opt/logsl/test_log.log*" #start_position => "beginning" type => "test1" } file { path => "/opt/lookups/testcsv.csv" start_position => "beginning" type => "test2" } Both types have common field values. I need to match those fields and map the corresponding values. (similar to outer join) something like below snippet if test2.ServerIP_1 == test1.ServerIP { add_field => { "city_ip" =>test1. ServerName_1} } can anyone help…

I have JSON files loaded under the same index. Two different types under the same index to be precise. I loaded both via logstash. I would need to merge fields somehow. Any direction is appreciated.