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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...