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

agoyal
Builder

Use dedup:

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

View solution in original post

0 Karma

agoyal
Builder

Use dedup:

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

View solution in original post

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.