if I have pulled people from a company table, using 'find people at these companies' is there a way to pull other data from that original company table into the people table such as the industry and sub vertical of their company
Yes, you can pull data like industry and sub-vertical from the original company table into your people table. When you use 'find people at these companies', Clay automatically creates a lookup column in your Find People table that links to the Find Companies table. This lookup column allows you to extract company attributes directly into your Find People table. To pull the data: 1. Locate the lookup column in your Find People table. 2. Click on the column header and select "Add as column" for the specific attributes you want (e.g., industry, sub-vertical). 3. If you've added new company data later, simply rerun the lookup in your people table to refresh the information. This method saves data credits and creates an integrated dataset combining individual and company information.
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.