Question

Report on Duplicates in GS

  • 30 September 2022
  • 1 reply
  • 16 views

Userlevel 2

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


1 reply

Userlevel 2
Badge +3

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.

Reply