I accidentally deleted column "Company Table Data -> Action -> Clay Company Lookup Reference a company in another Clay table Learn more We automatically try to map the correct columns for you. If any inputs are empty, just select the columns you want to map. Once all inputs are filled, you're ready to save and run!" This is the enrichment that matches the record in people table with record in company table and allows me to send the data. How to recreate it? Any way to do so?
Unfortunately, we can't recover deleted columns - they need to be recreated and data re-fetched.
To recreate your Clay Company Lookup enrichment:
Click "Add Enrichment" in the top-right corner [1]
Search for "Clay Company Lookup" in the enrichment library
Configure it to reference your company table and map the columns you need
Before recreating it though, try using Sculptor (top-right corner) - it can help you quickly rebuild this enrichment setup. Let me know if Sculptor helps or if you need more guidance on the manual setup!
Is that what you were looking for?
If you still need help recreating the Clay Company Lookup enrichment, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re facing?
It does not exist in enrichments.
You're right - "Clay Company Lookup" isn't a standard enrichment. What you need is a Lookup column to reference data from your company table. [1]
Try this instead:
Click "Add enrichment"
Search for "lookup" in the enrichment library
Configure it to pull data from your company table
This will let you match records between your people and company tables. Before setting it up manually though, definitely try Sculptor first - it can quickly help you rebuild this connection between your tables.
Did Sculptor help you set this up?
I tried using sculptor
also, I can't find the record id in company table
Got it - since Sculptor didn't help, let's find that record ID. In your company table, look for a column that might be labeled "Record ID", "ID", or similar. If you don't see one, you can create a lookup using the company domain instead.
For the lookup between tables, use "Lookup Multiple Rows in other Table" and match on company domains rather than record IDs - this is actually more reliable.
record id does not exist as well
No worries - you don't need a record ID. Use company domain instead, which is more reliable for matching between tables.
Set up "Lookup Multiple Rows in other Table" and use company domain as your matching field between the people and company tables. [1] This will connect your records without needing any special ID column.
What columns do you currently see in your company table? That'll help me guide you to the right domain field to use for matching.
If you still need help setting up the lookup using company domain or identifying the right columns, I’m here to assist. Would you like to share more about the columns you see in your company table so we can continue troubleshooting?
