Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
Gtm Career Advice
Member Spotlight
Share Full-time Jobs

Community Guidelines

Powered by Tightknit

Troubleshooting Missing Columns in Company Lookup Tables

·

·

I have a "Find companies" table with all the enrichments that come with it. I have a second table with some of the domains of table 1 but when I do a lookup I doesnt give me all the columns. Like f.e. Size and Industry are missing

Troubleshooting Missing Columns in Company Lookup Tables | Clay

5 comments

· Sorted by Oldest

Channeled
APP
·
·
When you perform a lookup between your "Find companies" table and a second table, some columns might be missing because the lookup column needs to be refreshed. To see all the columns, including Size and Industry, you need to re-run the company row in your second table. Clay automatically links your Find Companies table to other tables, allowing you to extract company attributes. However, if you've recently added new details to your Find Companies table, you need to manually update the lookup column in your second table to sync the updated information. To resolve this, force run the entire lookup column in your second table. This will ensure that all the latest data, including Size and Industry, is pulled from your Find Companies table.
Sources: Write to Table [Clay 101] - Clay University Find People [Clay 101] - Clay University
David K.
·
·
No it still doesnt give me size and industry
David K.
·
·
https://app.clay.com/workspaces/579323/workbooks/wb_0svjbdljq5qtiUNuhNz/tables/t_0svjxpyuWJRDRZNRTZQ/views/gv_0svjxpyAyndm2wbWaWU
Mark L.
·
·
Hi David. The lookup will only return the datapoints that exist as separate/independent columns. If there are datapoints in the original companies table that you want to pull in via the lookup, be sure to break them out into columns in the companies table. Datapoints that are still "nested" within the enrichment cells will not be pulled in by the lookup.
Mark L.
·
·
I think you might have what you needed here, so I'll close this out so you don't get pestered with any automatic reminders. Please keep in touch as new items come up.