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!

Splunk Edge Processor | Popular Use Cases to Get Started with Edge Processor

Splunk Edge Processor offers more efficient, flexible data transformation – helping you reduce noise, control ...

Introducing New Splunkbase Governance!

Splunk apps are essential for maximizing the value of your Splunk Experience. Whether you’re using the default ...

3 Ways to Make OpenTelemetry Even Better

My role as an Observability Specialist at Splunk provides me with the opportunity to work with customers of ...