To perform a lookup for emails from the people table to the company table, you can use the "Lookup Single Row in Other Table" feature in Clay. Here's how:
1. In your people table, add a new column using the enrichment panel.
2. Select "Lookup Single Row in Other Table" as the enrichment type.
3. Choose the company table as the target table.
4. Use the company domain as the matching data point.
This process will pull the enriched company data into your people table, linking the two tables automatically. You can then extract specific variables from the company table into your people table by clicking on the cells in this new column.
Remember, you can always rerun this lookup column to refresh the data whenever you add new company information.
Hi Rashi, thank you for reaching out.This video explains how to set up and use a lookup function in 2 minutes. I suggest using a unique identifier such as Company LinkedIn URL or company domain in order to find the row you are looking for. Let me know if this helps!
Hi THanks for this great video Stefano.
I am struggling to build a formula that tells me if the company in the current table can also be found in another table in the workbook. If yes, d like it to return "yes", if no, "no". Have been trying the AI prompt and chatgpt, nothing works.
Hi Rashi, when you correctly use the Lookup function, you could make it so that it checks company domain. If no matches are found in the other table, then it will return "0 contacts found", which should be your indicator of no contacts found. If contacts are found it will say "X Contacts Found", showing that the company in the other table is present. This can essentially act as your checker!
.png){kind=logo}
