Splunk Search

Produce single row by combining multiple row and column

Naveenkumar
Engager

Hi Splunk,

I have a table like below

Component Green Amber Red

Resp_time 0 200 400

5xx 0 50 100

4xx 0 50 100

 

I want to combine them to produce single row like below

Resp_time_Green  Resp_time_Amber Resp_time_Red 5xx_Green 5xx_Amber 5xx_Red 4xx_Green 4xx_Amber 4xx_Red

0 200 400 0 50 100 0 50 100

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| untable Component Level count
| eval Component_Level=Component."_".Level
| table Component_Level count
| transpose 0 header_field=Component_Level
| fields - column

View solution in original post

Naveenkumar
Engager

Thanks! Works like a charm!

0 Karma

isoutamo
SplunkTrust
SplunkTrust
Please accept that solution as it works.

ITWhisperer
SplunkTrust
SplunkTrust
| untable Component Level count
| eval Component_Level=Component."_".Level
| table Component_Level count
| transpose 0 header_field=Component_Level
| fields - column
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...