What I'm trying to do: I have a table called "Schools with Active SPED Postings" with a waterfall enrichment column called "Find HR/SPED Decision Makers" that returns up to 2 people per school. I need to expand this data so each person becomes their own row in a new table called "HR & SPED Contacts", with each contact row including: firstName, lastName, title, linkedinURL, email, plus all the parent school data (schoolName, schoolType, state, jobPostingLink, datePosted, hiringSignal, schoolWebsite).
What we've tried (all failed):
- 1.
Right-clicking the column header looking for "Write to other table" or "Expand to rows" options - these options don't exist in the menu
- 2.
Creating a new table and looking for "Import from Clay table" as a source option - this doesn't exist in the source menu (only options are: Find people, Find companies, Find jobs, Find local businesses, Import from CSV, Import from Salesforce, Import from HubSpot)
- 3.
Searching for "Write to Table" or "Send to Table" action when adding a new enrichment column - couldn't find this action in the enrichment search
- 4.
Using Sculptor AI to build a "Write to Table" action - Sculptor created the action configuration, but when setting it up and selecting "Send row for each item in a list", every option we try (the waterfall output column, a formula column extracting the people array, or individual waterfall step fields) gives a "Please add a valid list" validation error
- 5.
Trying to select nested fields like "Find Contacts at Company > people" from within the waterfall steps - these nested options don't appear in any dropdown menus
- 6.
Creating a "People Array" formula column to extract just the array data - even when selecting this as the list to loop through, still get "Please add a valid list" error
The core issue: We cannot figure out the correct method in Clay to take an array of people from a waterfall enrichment and expand it so each person becomes their own row in a new table. Every suggested method either doesn't exist in the UI or gives validation errors.
What I need: Clear step-by-step instructions on the correct way to loop through/expand a people array from a waterfall enrichment and send each person to a new table as individual rows, with the ability to map fields from both the people data and the parent school row data.
Table details:
Source table ID: t_0t3ti44xj8gNeZ4J6Hi (Schools with Active SPED Postings)
Destination table ID: t_0t3tnq7h9R2Fv6kws4e (HR & SPED Contacts)
Waterfall column ID: f_0t3tmhunyedKZBFFUPv (Find HR/SPED Decision Makers)
.png){kind=logo}
