Clay Icon
Join the Community
02 Support

Count the Company Appearances in a Table: Quick Reference to Find Prospects

Avatar of Charles M.Charles M.
·
·

Count the number of times a Company appears in a table. I want to be able to be able to see how many employees at a company have landed in a table I have set up. It's a scoring metric + useful to quickly reference. I when I have the count this will be saved to the Company table so I know how many prospects I am looking at for that account. The result I am looking for is for all rows to = 1 except for row 3 and 12 which should = 2 as they are listed twice in the table. https://app.clay.com/workspaces/162037/tables/t_RTVzLTE63GUl/views/gv_8IynPOlRkXDl

6 comments

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    We don’t have a great way to do this unfortunatley right now

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    but you can run “Lookup record in other table”

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    but instead run a lookup in the same table to essentially get a count

  • Avatar of Charles M.
    Charles M.
    ·
    ·

    Is there anyway to get a count on the number of employees you have in a table from the same company? I am struggling with the solution you mentioned.

  • Avatar of Charles M.
    Charles M.
    ·
    ·

    Here is how it's done incase anyone comes back to this query. Thanks Tommy!

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    So sorry for the delay here Charles, yep that’s it though!