Splunk Search

Remove duplicate values with same data

ahogbin
Communicator

I am attempting to remove duplicate occurrences from a results table.

What I have
ID 1 NewBusiness $123
ID 1 NewBusiness $123 *
ID 1 Endorsement $156
ID 1 Endorsement $0.00
ID 1 Endorsement $0.00
ID 1 Close $279.00
ID 1 Close $279.00 *

What I would like to get too.
ID 1 NewBusiness $123
ID 1 Endorsement $156
ID 1 Endorsement $0.00
ID 1 Endorsement $0.00
ID 1 Close $279.00

The values marked with * are the duplicates I am trying to remove. The end game is to remove the duplicates for NewBusiness and Close whilst keep duplicates for Endorsement.

The field values are policyNumber (ID 1) / Stage (Close) / Premium ($123)

As you can see from the above it is not possible (at least I don't think it is) to use the dedup command as there is no one item to de duplicate on.

Is there anyway of achieving what I am trying to achieve ?

Cheers.

Alastair

Tags (2)
0 Karma
1 Solution

renjith_nair
Legend

Try

<your base search>|streamstats count current=t reset_on_change=true by policyNumber Stage|where Stage=="Endorsement" OR count==1

Please refine the by clause fields according to your final requirement

Happy Splunking!

View solution in original post

renjith_nair
Legend

Try

<your base search>|streamstats count current=t reset_on_change=true by policyNumber Stage|where Stage=="Endorsement" OR count==1

Please refine the by clause fields according to your final requirement

Happy Splunking!

ahogbin
Communicator

Perfect... thank you so much. I cannot say how much this has helped.
Cheers
Alastair

0 Karma

sundareshr
Legend

Try like this | dedup policyNumber Stage Premium

ahogbin
Communicator

But that will also remove the duplicate stage of Endorsement (which I want to keep.

In any policyNumber there should only ever be 1 NewBusiness, 1 Close but there can be multiple endorsements (I I need to keep these)

0 Karma
Get Updates on the Splunk Community!

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...