# How do I remove duplicate row in leaderboard

**URL:** <https://community.glideapps.com/t/how-do-i-remove-duplicate-row-in-leaderboard/57813>\
**Category:** Ask for Help\
**Created:** [February 12, 2023, 1:28am UTC](https://community.glideapps.com/t/how-do-i-remove-duplicate-row-in-leaderboard/57813 "2023-02-12T01:28:05Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 12, 2023, 1:33am UTC](https://community.glideapps.com/t/how-do-i-remove-duplicate-row-in-leaderboard/57813/2 "2023-02-12T01:33:20Z")

</div>

This will work for you.

> [@Filter out duplicate items](https://community.glideapps.com/t/filter-out-duplicate-items/48988/2):
>
> Ultimately I would probably set things up differently. But to stick with your current setup, what you can do is create a template column that joins Business and Category together. Using that template, create a single relation back to itself. Then create a Lookup column that returns the Row ID from the relation. Finally create an IF column that checks if the Row ID matches the Lookup Row ID. If it’s a match, then return true, else false. Or you could probably just have the IF column return the Category name. This will give you a boolean value of true (or Category name) only in the rows that have that Business/Category combination the first time it appears in the data.

---

_[View the full topic](https://community.glideapps.com/t/how-do-i-remove-duplicate-row-in-leaderboard/57813)._