Re: how to rank or group similar data together ?

johnsasikumar · ‎03-20-2020

Hi all,

I have a requirement as below, When there is a name field, I want it to be ranked similar names together

Name

John
John
John
Jack
Jack
Jack
James
James
James

Similar names should be grouped as

John 1
John 1
John 1
Jack 2
Jack 2
Jack 2
James 3
James 3
James 3

Could some one help pls

woodcock · ‎03-20-2020

Like this:

... | streamstats dc(Name) AS Rank

richgalloway · ‎03-20-2020

Check out the cluster command.

---
If this reply helps you, Karma would be appreciated.