Hi Support! I have a workbook with 2 tables: a Companies table and a Contacts table. I’m trying to push the Company Name (from claygent) on the Companies table down to every related row in my Contacts (SFDC Seed) table. When I add the “Lookup Single Row in Other Table” (or “Write to Other Table”) block, Clay’s dropdown only shows my other ‘helper’ tables—the Contacts table never appears as a target. Both tables live in the same workbook, and each has a domain column. I need to match Companies.domain → Contacts.domain, then copy fields like Company Name Result into new columns on Contacts. But because Clay won’t list the Contacts table, I can’t map the domains or complete the write-back
The issue is likely due to Clay's linear data flow constraint. Data can only be sent in one direction (A → B → C), and loops aren't possible. Since you want to push data from Companies to Contacts, use Lookup Single Row in Other Table from your Contacts table instead. This allows you to pull Company Name data from the Companies table by matching domains. Set up the lookup in your Contacts table: ** Table to Search: Companies table ** Target Column: domain (in Companies table) ** Filter Operator: equals ** Row Value: domain column from Contacts table This will retrieve the Company Name from Companies table and add it to your Contacts table.
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.
