Adding People to Company Table with Lookup Function in Excel

How can I add people I found at companies to the table with the actual companies? With a lookup of some sorts. I want the data from people that work from the companies added to new columns in the table with the actual companies I have chosen. And if there are two people at the same company, I want them both on separate rows

5 comments

Clay
APP
·
·
To add people data to your company table with each person on separate rows, use the "Find Contacts at Company" enrichment: 1. In your company table, click Add Column > Add Enrichment 2. Search for "Find Contacts at Company" 3. Configure your search parameters for the type of people you want 4. Important: Select "Save results into the company table" option 5. Set a limit for how many contacts per company (or leave unlimited for all matches) This will add new rows to your company table - one row for each person found, with both the original company data and the person's information in the same row. Alternatively, you can use "Lookup Multiple Rows in other Table" from your company table to search a people table, using company domains as the matching data point. The first method is simpler for your use case since it automatically handles multiple people per company by creating separate rows.
Sources: Write to Table [Clay 101] - Clay University Find People [Clay 101] - Clay University
Daniel M.
·
·
I already did that, but I want to link those people back to the table where I found companies
Clay
APP
·
·
Your people table already has an automatic lookup column that links back to your original company table. This lookup column refreshes whenever changes are made to the company table, making it easy to pull company-level data into your people table. To access company data in your people table, click on any row in the Company column - this will show all fields from the linked company table. You can then pull out specific company fields (like company name, tech stack, revenue) and add them as new columns in your people table. If you've added new data to your company table, just rerun the lookup column in your people table to sync the updated information.
Sources: Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University
Clay
APP
·
·
Hello Daniel! Thanks for reaching out! To make sure I have understood it correctly, you want to pull in data from your People table into your Company Table? As you rightly mentioned you would have to do that through a lookup. Confused about the comment about wanting information about two people in separate rows in the Company table. For that you would have to technically duplicate the company row for the number of people found at that company. Even then if you perform a lookup it will pull in those many number of results for each row. Could you tell me more about the objective behind this and I can look into finding a workaround for you. Since we can have multiple people for one company and not the other way round, you can consider pulling company data into the people table instead of the other way round. Let me know what you think!
Channeled
APP
·
·
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.

Adding People to Company Table with Lookup Function in Excel | Clay