Given json with hashes
| makeresults
| eval _raw="{\"yes\":true,\"no\":false,\"a\":{\"x\":0,\"y\":0,\"z\":0},\"c\":{\"x\":1,\"y\":2,\"z\":3},\"d\":{\"x\":1,\"y\":4,\"z\":9}}"
| spath
"a", "c", and "d" are nested hashes. There are other fields, "yes" and "no" that are not hashes. What I am trying to do filter out non-hashes and then split into multiple row.
Name
x
y
z
a
0
0
0
c
1
2
3
d
1
4
9
The tricky part is that the top level field names, "yes", "no", "a", "c", "d" are not constant. However the sub fields "x", "y", "z" are. Thoughts?
... View more