How to Count Duplicated Domains in a Table

Wladimir D.

·

Hello team, I have a table and I want to count the number of duplicated domains within the same table. Any ideas?

✅1

9 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Wladimir D.
·
·
https://app.clay.com/workspaces/138811/tables/t_2Pr3OBYtdBJb/views/gv_9Qn7dqux90Wu
Clay Team
APP
·
·
Click on the domain column and then select "Dedupe"!
Wladimir D.
·
·
I want count for score lead 🙂
Clay Team
APP
·
·
Thanks for clarifying, Wladimir! You can use the Lookup Record integration for this
Clay Team
APP
·
·
Here's a video on how it works and our docs page for Lookup Record! We know it's called "Lookup Record in other table" but you can also use it in the same one to count those duplicate values within the same column and more. Let me know if you run into any issues!
Wladimir D.
·
·
🔥 Oh thank you, it's amazing, but I don't understand why I am getting this message when all I have as input is just a domain name
Loading attachments
Clay Team
APP
·
·
Sorry for the delay, Wladimir D.. It seems that there are way too many records and it's exceeding the cell's size limit as stated there, this is because it's not only to count but you can also pull in the associated records found in each row to append data (main use case).To get around that issue, it may be easier to copy/paste the domain column alone in a new table, and then run the lookup there to count them. You can then run a lookup in your original table to pull in the count instead.
Clay Team
APP
·
·
It's a hacky workaround but probably the best way to get around this restriction. The team has been talking about this size limit, so hopefully we'll have updates coming soon

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Wladimir D.
·
·
https://app.clay.com/workspaces/138811/tables/t_2Pr3OBYtdBJb/views/gv_9Qn7dqux90Wu
Clay Team
APP
·
·
Click on the domain column and then select "Dedupe"!
Wladimir D.
·
·
I want count for score lead 🙂
Clay Team
APP
·
·
Thanks for clarifying, Wladimir! You can use the Lookup Record integration for this
Clay Team
APP
·
·
Here's a video on how it works and our docs page for Lookup Record! We know it's called "Lookup Record in other table" but you can also use it in the same one to count those duplicate values within the same column and more. Let me know if you run into any issues!
Wladimir D.
·
·
🔥 Oh thank you, it's amazing, but I don't understand why I am getting this message when all I have as input is just a domain name
Loading attachments
Clay Team
APP
·
·
Sorry for the delay, Wladimir D.. It seems that there are way too many records and it's exceeding the cell's size limit as stated there, this is because it's not only to count but you can also pull in the associated records found in each row to append data (main use case).To get around that issue, it may be easier to copy/paste the domain column alone in a new table, and then run the lookup there to count them. You can then run a lookup in your original table to pull in the count instead.
Clay Team
APP
·
·
It's a hacky workaround but probably the best way to get around this restriction. The team has been talking about this size limit, so hopefully we'll have updates coming soon