.png){kind=logo}
Using Lookup Function to Access Fields from Multiple Tables
Is there a way to use lookup function to see the fields in multiple tables?
Is there a way to use lookup function to see the fields in multiple tables?
You can use the "Lookup Multiple Rows in Other Table" action to find and view fields across different tables in Clay. This function is specifically designed for retrieving multiple matching records from another table.Here's how it works: ** You can scan a column for specific values like company domain, name, LinkedIn URL, or other identifying information ** The lookup will return matching values from the target table * You can perform lookups within the same table or across separate tablesWhen tables are linked (like in workbooks), you can also extract specific variables you want from one table into another. For example, you can pull corresponding company information into your people table.Note: If you only need to find a single matching row, consider using the "Lookup Single Row in Other Table" action for better performance. Sources: Lookup Multiple Rows in Other Table with Clay Find People [Clay 101] - Clay University
Can I look up mutiple tables instead of one table?
No, the lookup function in Clay is designed to search within one table at a time. When using either the "Lookup Multiple Rows in Other Table" or "Lookup Single Row in Other Table" action, you can only specify one table to search in.However, there's a helpful workaround if you're working with related data: When tables are linked within the same workbook (like companies and people tables), you can extract specific variables from one table into another. This allows you to indirectly access data across multiple tables by first establishing the connections between them.For example, you can: ** Scan a column for specific values (like company domain, name, or LinkedIn URL) ** Pull corresponding information from the linked table * Perform lookups within the same table or on a separate one Sources: Lookup Multiple Rows in Other Table with Clay Find People [Clay 101] - Clay University
Great! Let me know if you have more questions.
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.