Splunk Search

Merge multipel events

ivanlesk
Engager

Hi,
I have something like this.

    ID    date(month)  avgValue1  avgValue2   avgValue3   ...
    111   2016-06      value      value       value       ...
    111   2016-07      value      value       value       ...
    222   2016-01      value      value       value       ...
    222   2016-03      value      value       value       ...
    ...   ...          ...        ...         ...         ...

I basically have two event per ID (event for month before and event for month after)
I would like to join/merge that in one event that would look something like this:

ID   avgValue1_before   avgValue1_after   avgValue2_before   avgValue2_after ...
111  value              value             value              value           ...
222  value              value             value              value           ...

Is this somehow possible?

Tags (2)
0 Karma
1 Solution

clara-fication
Super Champion
...|sort 0 + ID + "date(month)"|streamstats count by ID "date(month)"|eval beforeAfter=if(count==1,"before","after")|chart values(avgValue1) as avgValue1 values(avgValue2) as avgValue2 by ID beforeAfter

try something like this.

Solution Clara-fied!

View solution in original post

0 Karma

clara-fication
Super Champion
...|sort 0 + ID + "date(month)"|streamstats count by ID "date(month)"|eval beforeAfter=if(count==1,"before","after")|chart values(avgValue1) as avgValue1 values(avgValue2) as avgValue2 by ID beforeAfter

try something like this.

Solution Clara-fied!
0 Karma

ivanlesk
Engager
...|sort 0 + ID + "date(month)"|streamstats count by ID "date(month)"

should be without "date(month)" (if you count it by id and date count is allways =1)

But apart from that, it works. Thx

0 Karma

clara-fication
Super Champion

good call!

Solution Clara-fied!
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...