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.
Was that helpful?
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.