i have a table of 300 companies and i have a separate table that finds people from the original company table. i’d like to create a column on my company table that says how many people from this company are on the follow up table with the contacts.
You can use the "Lookup Multiple Rows" integration to count the number of contacts for each company. Here's how: 1. In your company table, add a new column using the "Lookup Multiple Rows" feature. 2. Set it to look up in your contacts table. 3. Match on a company identifier (e.g., domain, name, or LinkedIn URL). 4. Choose to count the matching rows. This will create a column showing how many contacts are associated with each company. Alternatively, you can use the "Find contacts" search in the enrichment tab. Save the results to your company table, which will add contact information directly to your company data. If you need more help, just ask to talk to a person for further assistance.
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.