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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...