Report on Duplicates in GS

  • 30 September 2022
  • 2 replies


How do I run a simple report to see if I have any duplicates in GS?


Best answer by TMaier 30 September 2022, 17:25

View original

2 replies

Userlevel 3
Badge +5

The beta Data Steward module does some of this for you on Company, through fuzzy matching of some sort - I’ve seen some false positives there though.


For other objects, and more reliable results, you should create a report on the object with “Count Distinct of GSID” in Show Me and whatever your indicator of duplicates would be in Group By. Ie: for Company, if you wanted to identify duplicates based on names matching, you would have Show Me: Count Distinct of GSID, Group By: Name. From there, you’re looking for any rows with a total >1, which you can add a Filter on Measures config to target for your convenience.

this actually helped me, thanks!