Clay Icon
Join the Community
02 Support

Counting Instances of People by Company ID with Lookup Multiple Rows

Avatar of Daniel C.Daniel C.
·
·

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

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Fatima
    Fatima
    ·
    ·

    Select the company ID column from both tables Company id Equals Company id

  • Avatar of Channeled
    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.