Organizing Data from Columns to Rows: Need Help with Table Feature

William R. · 2025-10-30 08:06:17.676152+00

Hey Everyone. I have a workspace where I have multiple titles in different column. Forexample I have Owner1, Owner2, Owner3, in different columns but I also have Apollo Person 1, 2, and 3 of the same company in other columns also. I want to send all these to a new table each in new row so that I can enrichments all at once in a more organized manner. The problem I am facing is that the "send table data" feature is very confusing. When I select the option "send row for each item in a list" it can only accept a "list". I have also made a list/array in a column combining all the names and titles but it still refuses to take this column as input. Please help.

Organizing Data from Columns to Rows: Need Help with Table Feature | Clay

Clay Support
APP
·
·
The issue is that your formula outputs a JSON string (text), not a native list that "Send row for each item in a list" requires. [1]
Solution: Remove JSON.stringify from your formula. Return the array directly:
_.compact([ {{Owner1}} && {name: {{Owner1}}, title: "Owner"}, {{Owner2}} && {name: {{Owner2}}, title: "Owner"}, // ... etc ])
This creates a proper list (indicated by {} brackets in Clay) that the feature will accept. [2]
Once fixed, "Send row for each item in a list" will flatten each contact into separate rows in your destination table. [3]
Clay Support
APP
·
·
Did that answer your question?
William R.
·
·
When I do that, the column itself starts giving error.
Loading attachments
Clay Support
APP
·
·
The "[object Object]" display means your column is showing objects correctly but not rendering them visually. This is expected behavior when returning arrays of objects. [1]
To use this with "Send row for each item in a list":
1.
Keep your formula as-is (returning the array without JSON.stringify)
2.
When setting up the write to table action, add the list column through the "Other data from this table" section rather than typing it directly
3.
Select your "All Contacts Array - Fixed" column from that section
This should recognize it as a valid list and allow you to map the name and title properties to your destination table columns. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help resolving the issue with the "send row for each item in a list" feature, I’m here to assist. Would you like to provide more details about the errors you’re encountering or the steps you’ve tried so far?
William R.
·
·
It also didn't work. I kept the formula as is. Then I added the list column through the "Other data from this table" and selected the array column. It worked but on the other I have just 10 blank rows
Loading attachments
Clay Support
APP
·
·
The blank rows in your destination table indicate that the source rows have empty values in the "All Contacts Array - Fixed" column when the write to table action runs. [1]
To fix this:
1.
Check if the source column has data - Verify that your "All Contacts Array - Fixed" column actually contains the array data in the rows you're trying to send
2.
Use conditional run settings - In your write to table action, add a condition to only run if the array column is not empty. This prevents blank rows from being created.
3.
Force run the column - If the array column should have data but appears empty, right-click the column header → Run Column → Force Run All Rows to regenerate the data.
The "[object Object]" display you saw earlier is normal for arrays of objects - it doesn't mean the data is broken, just that it's not rendering visually in that column.
Clay Support
APP
·
·
Did that answer your question?
William R.
·
·
When we removed the JSON.stringify from the formula, the column gave the error. Remember? Then you said that we should run this anyway.
Clay Support
APP
·
·
I understand this has been frustrating; I’ll connect you to a human agent who can help you further with this issue.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Kabeer A.
·
·
Hey you’re super close! The “Send Table Data” block in Clay only works when the input is a true list object, not a string that looks like a list (e.g. comma-separated text). Even if you’ve concatenated Owner1, Owner2, etc. into one column, Clay still reads it as text — that’s why “Send row for each item in a list” isn’t triggering. Here’s how to fix it:
1.
Create a Formula column that actually outputs a list, not a string for example:
2.
3.
[ {Name: {{Owner1}}, Title: {{Title1}}}, {Name: {{Owner2}}, Title: {{Title2}}}, {Name: {{Owner3}}, Title: {{Title3}}} ]
4.
Then use Send Table Data → “Send row for each item in a list” and point it to that formula column.
5.
In the “Map fields” section, reference the list’s internal keys (e.g. Name, Title) to push into the new table.
That’ll give you one clean row per person in your destination table so you can enrich them individually.
William R.
·
·
Hey Kabeer A.. What's the second point. It's missing. Also, how can I create this list?
William R.
·
·
I tried it Kabeer A.. When I remove the JSON.stringify, the column shows errors.
Loading attachments

17 comments