Using Lookup Function to Access Fields from 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

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.

Hi Bharat D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: