I have rows where data looks like..
Value1^Value2^Value3
Value4^Value5
Value6
Value7^Value8
My query (below)...
search here
| eval temp=split(FieldA,"^")
| table temp
Makes the following..
1.Value1
Value2
Value3
2.Value4
Value5
3.....
I need each value to be on a separate row. Additionally, I need the count of each time the row is returned in the event. Currently when I add "| stats count by FieldA as hits" no data is returned.
Please help!
... View more