Hi @Poojitha following the example from the documentation on spath: https://docs.splunk.com/Documentation/Splunk/9.2.1/SearchReference/Spath#3:_Extract_and_expand_JSON_events_with_multi-valued_fields Here is a runanywhere example: | makeresults
| eval _raw="{
\"Tag\": [
{\"Key\": \"app\", \"Value\": \"test_value\"},
{\"Key\": \"key1\", \"Value\": \"value1\"},
{\"Key\": \"key2\", \"Value\": \"value2\"},
{\"Key\": \"email\", \"Value\": \"test@abc.com\"},
]
}
"
| spath
| rename Tag{}.Key as key, Tag{}.Value as value
| eval x=mvzip(key,value)
| mvexpand x
| eval x=split(x,",")
| eval key=mvindex(x,0)
| eval value=mvindex(x,1)
| table _time key value
... View more