Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

University
Clay live events

Powered by Tightknit

Troubleshooting Company Import Using Lookup Multiple Rows Function | Clay

Troubleshooting Company Import Using Lookup Multiple Rows Function

·

·

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.

3 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
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 Clay Support.