Skip to main content
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 30, 2022 3:05 PM UTC
Solved

Report on Duplicates in GS

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

TMaier
TMaierAnswer
Helper ⭐️
Sep 30, 2022 3:25 PM UTC

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 ⭐️
Sep 30, 2022 3:25 PM UTC

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.

Translate
pchoe
Contributor ⭐️⭐️⭐️
Feb 29, 2024 8:16 PM UTC

this actually helped me, thanks!

Translate