How do I remove duplicate row in leaderboard

[rsykes999]

Hi All,

I have my data I require in the database however it will return a row for each person that are in the same team.

I want to just show 1 row per team.

You can see 2 rows for Team green - need that as 1 row. (1 distinct row per team)…

[Jeff_Hager]

This will work for you.

@Jeff_Hager

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.

[rsykes999]

Additional info from DB: can see the 2 x green team score.

[Jeff_Hager]

It’s a type of column.

[rsykes999]

I have created the single relation column below, hoping it is correct (See image). However I do not understand next step “Then create a Lookup column that returns the Row ID from the relation”, What relation is this set against? (The single one?) What is the Row ID?

[rsykes999]

Okay - so table did not have unique key column. So I have added it and see if that helps me.

[Jeff_Hager]

@rsykes999

What relation is this set against?

The relation is similar to to your RelationTeamscore, except that it’s only a single relation.

@rsykes999

What is the Row ID?

You add it as a new column, just like I’m showing in the screenshot.

[rsykes999]

I tried this however does not look correct… as all greyed ticks?

Basically not able to differentiate TRUE -vs- FAILED so I have not done something correctly. Is my IF statement correct?

[Jeff_Hager]

Your lookup is an array, so that tells me that your lookup is looking at the entire table, or your single relation is not a single relation.

[rsykes999]

My lookup is looking up ROW ID - so that is the entire table.
The Single relation is created but not referenced to be used anywhere in your comments.
Also the ROW ID I created are new values that do not relate in any way shape or form to the URLTeam and ChallengeName (fields that were combined together as template column).

[rsykes999]

My single relation looks like (though is not part of the IF column statement)

[nathanaelb]

In your lookup column, look up RowID through the single relation you created, don’t look up the entire RowID column of the table.

[rsykes999]

I think this is getting closer. See my Lookup pointing at single relation
however getting Falses now in the If column:

[rsykes999]

Single relation being:

and IF column being:

[nathanaelb]

In the configuration of the lookup column, when you click on the dropdown menu, do you see SingleRelation at the root level towards the top of the list?

[rsykes999]

Yes. What should I select?

[Jeff_Hager]

@rsykes999

The Single relation is created but not referenced to be used anywhere in your comments.

Right here.

@Jeff_Hager

Then create a Lookup column that returns the Row ID from the relation.

Select the single relation and then RowID.

[rsykes999]

Done this Jeff. Then what is next step to get the If statement working?

[rsykes999]

Actual think I may have it working now. (if statement looks good)

[rsykes999]

Works. Thanks so much to all the help. Support here is really solid. It is my brain trying to -understand- the logic is sticking point. Can only learn.