Counting Instances of People by Company ID with Lookup Multiple Rows

I am trying to use Lookup Multiple Rows in another table to count the instances of people for a specific company. I am using a unique company ID as the identifier, filter operator equals but not sure what to put in Row Value to achieve this.

4 comments

Channeled
APP
·
·
To count the number of people for a specific company using Lookup Multiple Rows in Clay: 1. Use the "Lookup Multiple Rows in Other Table" action. 2. Set up the inputs: • Table to Search: Select your people table • Target Column: Choose the column with the company ID • Filter Operator: Select "equals" • Row Value: Enter {{unique_company_id}} (replace with your actual column name containing the company ID) 3. The action will return all matching rows. To get the count, use a formula to count the returned rows. This method allows you to scan for the company's unique ID and count how many cells match that value.
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University
Channeled
APP
·
·
Fatima
·
·
Select the company ID column from both tables Company id Equals Company id
Channeled
APP
·
·
To set up Lookup Multiple Rows to match company ID columns: 1. Use the "Lookup Multiple Rows in Other Table" action. 2. Set the inputs: • Table to Search: Select the table with company IDs • Target Column: Choose the company ID column in the searched table • Filter Operator: Select "equals" • Row Value: Enter {{company_id}} (replace with your actual column name containing the company ID in the current table) This setup will match company IDs across both tables, returning all rows where the IDs are equal.
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University

Counting Instances of People by Company ID with Lookup Multiple Rows | Clay