Counting Instances of Companies in a Separate Table: Need Help!

Hi i have a table with repeated company rows due to a different row relating to that company. I have created a seperate table with deduped companies. I simply want to look up the other table and count the number of instances where the company is in a column to give me a count on the number of pieces of info relating to that company. Lookup doesn’t do a count and claygen doesn’t like it either. Any pointers would be much appreciated. Thanks!

4 comments

Channeled
APP
·
·
To count the number of times each company appears in your original table and display that count in your deduped companies table, you can use the "Lookup Multiple Rows" integration in Clay. Here's how: 1. In your deduped companies table, add a new column using the "Lookup Multiple Rows" integration. 2. Set it to look up the company name or domain in the original table. 3. Choose the "Count" option to count occurrences. 4. Run the integration to populate the new column with counts. Alternatively, you can use the "Count Occurrences of Items" feature: 1. Select the company column in your original table. 2. Use the "Count Occurrences of Items" integration. 3. Use the "write to table" feature to add the results to your deduped companies table. These methods will give you the count of each company's appearances in your original table.
Source: Count Occurrences of Items with Clay
Bo (.
·
·
Hey, Thanks for explaining — this sounds like exactly the kind of thing covered in this quick walkthrough: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7
Let me know if you have more questions
Ross R.
·
·
no sorry - I am looking for a row count in a table lookup based on a column. E.g. Table 1. X Domain is in 6 rows. In table 2. I have a X domain. I want to look up how many rows Domain is in as this will tell me how many leads I have against that domain.
Bo (.
·
·
Hey, would you mind recording a quick video to show what you’re trying to do? From your description, it sounds like a standard lookup, but I want to be sure I’m understanding it correctly so we can help you faster.