Dashboards & Visualizations

How do you move duplicate rows in a table?

rohanmiskin
Explorer

I do my search and use the table keyword to get the results and the fields in a table

The table i get is like this

field1|field2|field3|field4
1     |2     |3     |4
1     |2     |3     |4
1     |2     |3     |4
1     |2     |3     |4
5     |6     |7     |8   
5     |6     |7     |8
5     |6     |7     |8
5     |6     |7     |8

The result i want is

field1|field2|field3|field4
1     |2     |3     |4
5     |6     |7     |8

my search query is
mySearchCriteria | table field1,field2,field3,field4

0 Karma
1 Solution

AKG1_old1
Builder

Use dedup:

mySearchCriteria | table field1,field2,field3,field4 | dedup field1,field2,field3,field4

View solution in original post

0 Karma

AKG1_old1
Builder

Use dedup:

mySearchCriteria | table field1,field2,field3,field4 | dedup field1,field2,field3,field4

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...