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