Archive

How do you move duplicate rows in a table?

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

Builder

Use dedup:

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

View solution in original post

0 Karma

Builder

Use dedup:

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

View solution in original post

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!