Splunk Search

Transform a field into table view

MikeJu25
Path Finder

Hi,

I have a field called sequence_anomalies which consists of a lot of individual elements. Once I made it into a table, it looks like below. Now I am wondering if it's possible to make a table view where each row only contains one element instead of all elements being in one row. 

image.png

image.png

 Thank you in advance!

Regards,

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| eval sequence_anomalies=split(sequence_anomalies," ")
| mvexpand sequence_anomalies

By the way, the images are quite small, it would have been better to have pasted the data into a code block </>

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| eval sequence_anomalies=split(sequence_anomalies," ")
| mvexpand sequence_anomalies

By the way, the images are quite small, it would have been better to have pasted the data into a code block </>

MikeJu25
Path Finder

Sure will do in the future! Thank you for your answer! 

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...