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):
Right-clicking the column header looking for "Write to other table" or "Expand to rows" options - these options don't exist in the menu
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)
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
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
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
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)
I receive the "Please add a valid list." error when selecting that waterfall column.
Where is the "Other data from this table: section? Am I still performing the "Send table data" action?
That is not an option available. All i can do is select columns under "send additional info" Is this where i should select "Find HR/SPED Decision Makers"?
https://app.clay.com/workspaces/804485/workbooks/wb_0t3ti43pRtw7DF6rQss/tables/t_0t3ti44xj8gNeZ4J6Hi/views/gv_0t3ti452eufnccAEuEw
Sure thing. Thanks!
