Splunk Search

How to merge two rows into one ?

marioosh2
Engager
How to convert table like this (2 rows per topic):
 
topic   mbean_property_name bytes
A   BytesOutPerSec  60376267182
A   BytesInPerSec   12036381418
B   BytesInPerSec   6246693551
B   BytesOutPerSec  6237320887

to
topic   BytesOutPerSec  BytesInPerSec
A   60376267182 12036381418
B   6237320887 6246693551


Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| xyseries topic mbean_property_name bytes

View solution in original post

0 Karma

marioosh2
Engager

Thank You very much :slightly_smiling_face:

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

Hello @marioosh2 

I'm Vatsal from Community Moderator team,

If answer from @ITWhisperer resolved your question then please accept the answer by clicking on "Accept as Solution" underneath the answers from @ITWhisperer , so that future community member can get help from it.

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| xyseries topic mbean_property_name bytes
0 Karma
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 ...