Splunk Search

transpose but with one column being a group by column

harshpatel
Contributor

Hi,

So at the current state of my search results in following format:

key fieldname   fieldvalue
k1  name1           0 day
k1  name2           N/A
k2  name1           0 day

I want it to be something like following but I am not sure how to achieve this.

key   name1 name2
k1    0 day N/A
k2    0 day       

Thanks,
Harsh

0 Karma
1 Solution

jpolvino
Builder

Try putting this at the end:
| xyseries key fieldname fieldvalue

View solution in original post

jpolvino
Builder

Try putting this at the end:
| xyseries key fieldname fieldvalue

Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...