I have some JSON (raw event) like below, this is one event: {     "place": "bar",     "stock": [                      {                        "brand": keith                        "type": drink                        "owner": Tom                       }                       {                        "brand": qfarm                        "type": food                        "owner": Mike                       }                      {                        "brand": blue                        "type": drink                        "owner": Jerry                       }                       {                        "brand": redriver                        "type": food                        "owner": Don                       }                    ] }   System already extracted field “place”, “brand”, “type”, “owner”. What I would like is to extract “brand” into new field “brand_drink” or “brand_food” depends on “type” is drink or food. And do the same for “owner”. In this example, there’s 4 items under “stock”, there’s other events have more or less which might have to use loop.   Been struggling with this. Can someone help please? ... View more