How to Remove Duplicate Domains and Find Unique Ones in a List

·

Hello, I need to remove duplicate domains from a list and locate the unique ones in another list, but cannot figure out how to do that, anyone here to help?

✅

1

9 comments

· Sorted by Oldest

Tsolak T.
·
·
https://app.clay.com/workspaces/116096/tables/t_fzUtouqLDzRh/views/gv_9LF4TvjfReux (the link that I have the duplicates in) https://app.clay.com/workspaces/116096/tables/t_His5icRvAGC8/views/gv_1DWidjrLaxja (the clean list I want to work on without the duplicates)
Clay Team
APP
·
·
Responded on other thread!
Tsolak T.
·
·
what other thread?
Tsolak T.
·
·
Anjali D.
Anjali D.
·
·
Hi Tsolak! While one option is to move leads onto a new table, for which you can use the Write to Table enrichment (tutorial attached below), you can also try deduping within your existing table. To dedupe within your table, navigating to the title of a column, and click on ‘dedupe’ in the drop down menu (attaching a screenshot to help with that below). Write to Table: https://www.loom.com/share/bec6c4fd00a84e788ad4b6fedec5d57f?sid=a6acc25d-6d75-47a0-a2a6-885c9d683db7
Clay Team
APP
·
·
Another question,
Clay Team
APP
·
·
Question 1: Is there a way to search for company lookalikes, without having duplicates in the answers? Question 2: Is there a way to search for grocery stores that have 2 or more locations? Question 3: is there a way to search for companies that do not include in our CRM? Like referring to a list it give us results that do not include there?
Tsolak T.
·
·
Anjali D. thank you in advance ❤️
Clay Team
APP
·
·
Hey Tsolak T., I replied to the thread regarding those questions but let me know if you have any additional thoughts. Closing this for now

Loading comments

Tsolak T.
·
·
https://app.clay.com/workspaces/116096/tables/t_fzUtouqLDzRh/views/gv_9LF4TvjfReux (the link that I have the duplicates in) https://app.clay.com/workspaces/116096/tables/t_His5icRvAGC8/views/gv_1DWidjrLaxja (the clean list I want to work on without the duplicates)
Clay Team
APP
·
·
Responded on other thread!
Tsolak T.
·
·
what other thread?
Tsolak T.
·
·
Anjali D.
Anjali D.
·
·
Hi Tsolak! While one option is to move leads onto a new table, for which you can use the Write to Table enrichment (tutorial attached below), you can also try deduping within your existing table. To dedupe within your table, navigating to the title of a column, and click on ‘dedupe’ in the drop down menu (attaching a screenshot to help with that below). Write to Table: https://www.loom.com/share/bec6c4fd00a84e788ad4b6fedec5d57f?sid=a6acc25d-6d75-47a0-a2a6-885c9d683db7
Clay Team
APP
·
·
Another question,
Clay Team
APP
·
·
Question 1: Is there a way to search for company lookalikes, without having duplicates in the answers? Question 2: Is there a way to search for grocery stores that have 2 or more locations? Question 3: is there a way to search for companies that do not include in our CRM? Like referring to a list it give us results that do not include there?
Tsolak T.
·
·
Anjali D. thank you in advance ❤️
Clay Team
APP
·
·
Hey Tsolak T., I replied to the thread regarding those questions but let me know if you have any additional thoughts. Closing this for now