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!

What’s New in Splunk Cloud Platform 9.1.2308?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2308! Analysts can ...

Index This | Why do they call it hyper text?

November 2023 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

State of Splunk Careers 2023: Career Resilience and the Continued Value of Splunk

For the past three years, Splunk has partnered with Enterprise Strategy Group to conduct a survey that gauges ...