Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Counting Unique Companies in a Database of Contacts | Clay

Counting Unique Companies in a Database of Contacts

·

·

Team: how do I count unique records in a column? I have a database of contacts, and I want to know how many unique companies are represented. Thanks!

2 comments

· Sorted by Oldest

Loading comments

Channeled
APP
·
·
You can count unique companies in your database using two approaches: 1. Using the Count Occurrences integration: • Select your company column as the input • Enable the "Case-Insensitive" option to ensure accurate counting • The results will show you how many times each company appears 2. Using the Normalize and Deduplicate integration: • Input your list of company names • Enable "Remove empty values" if needed • This will give you a clean list of unique companies without duplicatesFor more precise counting, you can also use the Lookup Multiple Rows feature to scan your table for specific company identifiers like domains or names. Sources: Count Occurrences of Items with Clay Normalize and Deduplicate a List with Clay
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.