When I find companies and then I find people at those companies, How Do I import company info into the "people at companies" table?
To import company information into your "people at companies" table, you can use the "write to table" feature or a lookup column. Here's how: 1. First, find companies and people using the "Find Companies" and "Find People at These Companies" actions. 2. Clay automatically links your Find Companies table to your Find People table. 3. To bring company data into your people table, add a lookup column in your people table that references the company data. 4. Alternatively, use the "Lookup Multiple Rows" enrichment in your company table to pull specific fields from the people table into your company table. 5. If you want both company and people data in one table, you can use the find contacts search option in the enrichment tab and save the results into the company table. This way, you can view and use company information alongside your people data efficiently.
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.
There is supposed to be a 'lookup' option when I add column... but it is not displaying
when you click on this you can find all info from company table then you can map them what you need