Remove duplicates

Ask for Help
1

I have a sheet with listings. There are a lot of duplicates which is intentional because the same item may have been listed many times. However, when I show them in a collection, I don’t want to show all the duplicates. When someone selects and item, it takes them to graph and shows the item’s price over time. That works fine. However, I don’t know how to just show the distinct items in the collection component.

2

Try creating a single relation from the main column of the items (Row ID or Name) to the same column. It’s important that you uncheck ‘Multiple’. Then display that relation as the source of the collection.

EDIT: This answer is incorrect. See Thinh’s correct approach below.

3
  • Creating a single relation from the item’s rowID to itself.
  • Create a lookup to retrieve the rowID from the relation. That will be the first ID among all duplicates.
  • Filter your collection by rowID equals “first ID”.
1 Like
4

This worked perfectly. Thank you!

1 Like
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.