Hi all,
I have a requirement as below, When there is a name field, I want it to be ranked similar names together
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
Like this:
... | streamstats dc(Name) AS Rank
Check out the cluster
command.