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 *

View solution in original post

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
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.