Splunk Search

How can I transpose/transform data in multiple rows?

quahfamili
Path Finder

Hi all,

I was preparing my data to be visualised. However, I met with a challenge. The below is an extract of my data:

alt text

My desire output would be:

alt text

Note that the key value is dynamic, there could be 10 to 20 numbers of keys.
Anyone has any idea to achieve this?

Thanks in advance!

0 Karma
1 Solution

vnravikumar
Champion

Hi

Try this

your query... 
| table key,value,field1,field2 
| eval {key}=value 
| fields - key, value 
| table *

View solution in original post

vnravikumar
Champion

Hi

Try this

your query... 
| table key,value,field1,field2 
| eval {key}=value 
| fields - key, value 
| table *

quahfamili
Path Finder

Hi it works, 1 more question for {} how do i control the numbers of keys? it seems like defaulted at 24 columns.

0 Karma
Get Updates on the Splunk Community!

Devesh Logendran, Splunk, and the Singapore Cyber Conquest

At this year’s Splunk University, I had the privilege of chatting with Devesh Logendran, one of the winners in ...

There's No Place Like Chrome and the Splunk Platform

WATCH NOW!Malware. Risky Extensions. Data Exfiltration. End-users are increasingly reliant on browsers to ...

Customer Experience | Join the Customer Advisory Board!

Are you ready to take your Splunk journey to the next level? 🚀 We invite you to join our elite squad ...