Remove duplicates

  • 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