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!

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team on ...