Splunk Search
Highlighted

How do I add every two rows into a seperate column?

New Member

I want to add every two rows in a column and display them in new column as new total:

Column1
1

2
5

7
8

9

NewTotalColum

3

12

17

Any leads will be helpful.

Tags (3)
0 Karma
Highlighted

Re: How do I add every two rows into a seperate column?

SplunkTrust
SplunkTrust

@akhera,

Try this,

your search|streamstats current=f window=1 last(Column1) as prev|eval rowno=1|accum rowno
|eval Total=if(rowno%2==0,Column1+prev,null())|fields - rowno,prev

You shall change the logic to display data in alternative columns if needed

View solution in original post

Highlighted

Re: How do I add every two rows into a seperate column?

Splunk Employee
Splunk Employee

Hi @akhera,

Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!

0 Karma
Highlighted

Re: How do I add every two rows into a seperate column?

New Member

@mstjohn_splunk @renjith.nair This is really helpful and it solved my issue. thanks for your help and support.

0 Karma