.png){kind=logo}
How to Count Duplicated Domains in a Table
Hello team, I have a table and I want to count the number of duplicated domains within the same table. Any ideas?
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 😉
Click on the domain column and then select "Dedupe"!
I want count for score lead 🙂
Thanks for clarifying, Wladimir! You can use the Lookup Record integration for this
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!
🔥 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
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.
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