Splunk Search

Remove duplicate value from fields

timAugustine
Loves-to-Learn

I'm trying to remove the duplicates in a field as described below


EVENT_No     |     Fieldname
1                               a
                                  b
                                  c

2                               a
                                  b

3                               c
                                  a

Is there a way I can make it look like this?

EVENT_No     |     Fieldname
1                               a
                                  b
                                  c

0 Karma

timAugustine
Loves-to-Learn

Hi all,

I found a solution to this I used mvexpand command this way:

..| mvexpand Fieldname | dedup Fieldname | format

This pretty much was what I was looking for!

0 Karma
Get Updates on the Splunk Community!

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...