Making a Nested Object String Iterable for Table Rows

Hi again Clay S., Just wondering if you could help me on this one, where i need to make this string iterable? I wanted to create rows to other table, but I its hard to do it on a nested object. here is the table. Again thank you for the help! ❤️

12 comments

Channeled
APP
·
·
To create rows in another table from a nested object or a string that represents a list, use the Write to Table feature with the "Send row for each item in a list" option. This will flatten your list or iterable string, turning each item into its own row in the destination table. Steps: 1. In your source table, ensure the cell contains a list (not just a plain string). 2. Click Actions → Send table data. 3. Select the destination table. 4. Choose Send row for each item in a list. 5. Map the relevant properties to columns in the new table and save. This process is ideal for handling nested or array-like data, making each item individually accessible in the target table.
Sources: Send table data | Documentation | Clay University Send table data | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Table [Clay 101] - Clay University
Tanvi R.
·
·
Hi Christopher, thanks for reaching out! I see what you're trying to do here! Right now, each field that you want to create as it's own row needs to have its own field. Our write to table enrichment cannot parse a string. Instead, you could parse this object by applying a formula here when you're selecting a list from a column. I'm not seeing the row that you sent over in the screenshot, did you delete this from your table by chance? The formula approach would be something like this:
(33 kB)
1
Christopher O.
·
·
Thank you, I figured out a better solution! Just forgot to update this thread ❤️ Thank you Tanvi R.
Tanvi R.
·
·
What did you end up doing Christopher? Glad you found a better solution!
Christopher O.
·
·
i checked the bot told me to try. the “send table data” its pretty neat! ❤️
Tanvi R.
·
·
Ah yes, this is our newer iteration of write to table! What did you like about it compared to write to table?
Christopher O.
·
·
its like the same to “write to table” but yet it feels more powerful since you have control on what data you want send.
Tanvi R.
·
·
Will share this feedback with our team, thanks Christopher! Let us know if you have any further questions.
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Christopher O.!
Christopher O.
·
·
thank you! ❤️
Clay
APP
·
·
Thank you so much for sharing your feedback Christopher O.!

Making a Nested Object String Iterable for Table Rows | Clay