Getting Data In

Split MV into new table rows

ereed18
Engager

I have rows where data looks like..

  1. Value1^Value2^Value3
  2. Value4^Value5
  3. Value6
  4. 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!

Tags (2)
0 Karma
1 Solution

somesoni2
Revered Legend

To see every field value in separate row

search here | eval temp=split(FieldA,"^") | table temp | mvexpand temp

To get the count

search here | eval temp=split(FieldA,"^") | table temp | stats count as hits by temp

View solution in original post

somesoni2
Revered Legend

To see every field value in separate row

search here | eval temp=split(FieldA,"^") | table temp | mvexpand temp

To get the count

search here | eval temp=split(FieldA,"^") | table temp | stats count as hits by temp

ereed18
Engager

I had to move "mvexpand" in front of "table", but that works. Additionally, count had to go to the end when I was trying to count, table the field and count then expand the rows. I think my order might have caused my issues. Thanks!

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...