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 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...