Skip to main content
Contributor ⭐️⭐️⭐️⭐️⭐️
September 30, 2022
Solved

Report on Duplicates in GS

  • September 30, 2022
  • 2 replies
  • 171 views

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

Best answer by TMaier

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.

2 replies

TMaier
TMaierAnswer
Helper ⭐️
September 30, 2022

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.

pchoe
Contributor ⭐️⭐️⭐️
February 29, 2024

this actually helped me, thanks!