Replace score with highest score for the same "Name"

[asarma]

Hi,

I need some help for the below scenario. Any guidance help is greatly appreciated.

Replace score with highest score for the same "Name". For the same person all score should become equal to the highest score. So number of rows will be same as before, the name field will remain the same, only the score will be replaced with highest score for all rows.

Thanks.

Name	Scoring
John T	4
Adam S	1
John T	0
Adam S	2
Terry	0
Scott	5
John T	4
Scott	1
John T	2
Adam S	3
Bill	2
Bill	1
Terry	6
John T	7

[Lwt08 · Accepted solution]

Hi @asarma,

I would recommend for using a sort tool on both the columns ensuring Scoring is descending. Then use a unique on the Name to get each name mapped to their highest score. Then simply join that list to your original list (can be before or immediately after sort) ensuring the original list is on the L tag and joining on name only. Then the J output tag should have what you want.

[asarma]

Hi @Lwt08,

Thanks for sharing the solution and thanks for your help.

Regards,

asarma