Troubleshooting Company Import Using Lookup Multiple Rows Function

Mark S. · 2025-02-27T16:48:48.930989+00:00

Hi, I'm trying to import companies from one table to another but struggling. I'm using the lookup multiple rows function. The table I"m trying to get the companies to is here: https://app.clay.com/workspaces/346206/tables/t_Nu6GMDqm7Hq4/views/gv_8Bc2ZHAMtzFS and the one I'm trying to get them from is here: https://app.clay.com/workspaces/346206/tables/t_hGSNyyojXs2m/views/gv_p44WXyFmQJ5i . If you can help it will be much appreciated.

To import companies from one table to another using the Lookup Multiple Rows function: 1. Add a new column in your destination table by clicking "Add Column" > "Add Enrichment" 2. Search for and select "Lookup Multiple Rows in Other Table" 3. Choose the source table you want to look up companies from 4. Select a matching data point to connect the tables (like company domain, name, or other identifying value) 5. Choose which fields from the source table you want to bring over to your destination table The lookup will scan the specified column for matching values and retrieve the corresponding company data. You can use this to find and import multiple matching records between tables. Make sure to map the data you want to bring over properly in the column settings. You can select specific properties from the source table to include in your destination table.

Source: Write to Other Table | Documentation | Clay University

3 comments