TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
duplicate names
Hi I have a contact table and would like to create a report that shows duplicate name is this possible

Date Created
8/19/2018 3:12:33 AM
Date Updated
8/21/2018 10:48:27 AM
Rui Oliveira 8/19/2018 3:22:35 AM
Yes it is possible to indentify duplicates. I can help you.

The table is on Excel or Word or other?


Accounts 8/19/2018 3:29:53 AM
No it is in team desk. I need to be able to write a report in team desk or put a formula in that gives me a list of duplicate entries within team desk. I was thinking of doing a report and using a custom formula but don't know what to put in as the formula
basenine 8/19/2018 6:15:24 AM
You should be able to do [COLUMN NAME]=[COLUMN NAME] in the view.

Navigate to the "Matching" section of a view in setup -->
Select "Custom formula" -->

The trouble you might find is if the data has been entered in differently in two different:

"Bert Simson" in one record and "Bert Simpson" in another...typo error nulls the "="

You could do a couple of different variants of the Match condition...maybe Phone number?

If you use a phone number, you might be able to use the formatting function built into the column first, so you've a better chance of the numbers matching
Accounts 8/19/2018 11:33:48 AM
that doesn't work it comes up with everything
Slava Shinderov  Staff  8/19/2018 12:34:46 PM
Please review following example:
basenine 8/19/2018 4:46:48 PM
you're correct!

I tried on small sample before sending through and it 'appeared' to have worked.
On the larger sample...nup!
Slava's solution works...multi relation is the avenue to pursue.
Philipp (JFDI/Teamdesk) 8/21/2018 10:48:27 AM
Hi Slava
Do you by any chance have a solution to the Simson versus Simpson problem put up by Brett above.

Maybe a Soundex function or a function which finds x% of the characters to be the same?
Back to Search Results