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
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
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
Hi @ITWhisperer
Thanks for this perfect solution !!