Knowledge Management

How to Transpose Group of Columns in Rows?

mxh7777
Path Finder

Hello,
I'd like to transpose a table results by grouping by columns.

Here is my table

time1 event1 time2 event2 time3 event3
01/01/2022 titi 02/01/2022 toto 04/01/2022 tata

 

I'd like to transpose this structure in this way

time content
01/01/2022 titi
02/01/2022 toto
04/01/2022 tata

 

I didn't find a way to solve this

Thans in advance

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

One way might be something like this

| eval row=mvrange(1,4)
| mvexpand row
| foreach event*
    [| eval content=if(row=<<MATCHSEG1>>,<<FIELD>>,content)]
| foreach time*
    [| eval time=if(row=<<MATCHSEG1>>,<<FIELD>>,time)]
| table time content

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

One way might be something like this

| eval row=mvrange(1,4)
| mvexpand row
| foreach event*
    [| eval content=if(row=<<MATCHSEG1>>,<<FIELD>>,content)]
| foreach time*
    [| eval time=if(row=<<MATCHSEG1>>,<<FIELD>>,time)]
| table time content

mxh7777
Path Finder

Hi @ITWhisperer 

Thanks for this perfect  solution !!

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...