.png){kind=logo}
Writing Each Item to a New Row in a Table: Tips and Formulas
How can I "write each item to a new row in the same table"? I have tried using GPT, Claygent different formulas, none of them are giving the correct output.
How can I "write each item to a new row in the same table"? I have tried using GPT, Claygent different formulas, none of them are giving the correct output.
You can't
are you wanting to push an array of objets into their own row?
If so, you should use "write to other table"
you'll create a new table with individual rows, each row corresponding to an object in the array and each column corresponding to a field in the object
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
I want to create new rows for each item/value within the same table.
I can write to other table and it works fine, but instead of writing to other table, I want to write in the same table by creating new rows
Hi Fahad, thanks for reaching out. Just to clarify: you want the same datapoint to appear across a list of leads here? Just gathering context to best address your use case.
Hi Fahan, I understand your point – you’re aiming to extract each person from your Apollo search into individual rows within the same table. Unfortunately, Clay won’t support this because it would disrupt the structure of your current table, where each row is dedicated to a single company lead. I recommend continuing with the setup you’ve already implemented, where leads are written to a separate table using the write to other table enrichment column. This approach will allow you to manage each lead as an individual row without affecting the original table’s format. Here's a quick guide on how to set up the write to other table column in case you're run into any issues with it: 1. Make sure your Clay API key is linked correctly. 2. Find and set up the write to table enrichment column by clicking on Add Column > Add Enrichment > Search and select "write to table" https://downloads.intercomcdn.com/i/o/1198904361/3f67448e206777df45b95b0c/CleanShot-2B2024-09-04-2Bat-2B22_37_07.gif?expires=1729610100&signature=d808bb7cded0af2c66d0c087c8fca96d8c050e9e11c31430ab93bf94e7db4be3&req=dSEuHsB%2BmYJZWPMW1HO4zUOGxdVCdTrd3XP6pls40EUixA%3D%3D%0A 3. You can now choose to parse your arrays into an existing table or create a new blank table for them, by clicking on "new table": https://downloads.intercomcdn.com/i/o/1198904362/2d0802e8f2b400ae2661cfc6/CleanShot-2B2024-09-04-2Bat-2B22_45_05.gif?expires=1729610100&signature=5251eefe97686055f99c761f39d5519583b16319f48ae2ecfaa4ffb939ea278d&req=dSEuHsB%2BmYJZW%2FMW1HO4zeoz80w8wb%2BJqPOJ9fQhK2lj7g%3D%3D%0A 4. We can now neatly write our array of objects into individual rows by inserting a column in the 'Select a List from a Column' field. Type a forward slash, choose the column containing the arrays, open its properties, and click "insert all items". https://downloads.intercomcdn.com/i/o/1198904363/5b8ff331300c2f7d8c10a39f/CleanShot-2B2024-09-04-2Bat-2B22_53_01.gif?expires=1729610100&signature=4ba2cf19d95b2dad4b5b0fc65fc011ff1b73cb61ab587ae0907bd00db7b58ee2&req=dSEuHsB%2BmYJZWvMW1HO4zT205jmGxlEeR2g4Gfhv9uUhDw%3D%3D%0A 5. Now the last thing we'll have to do is specify which objects from the array we want to write to the new table, and to which columns we want to map them. We'll be able to select columns which are existing or create new ad-hoc columns for this purpose: https://downloads.intercomcdn.com/i/o/1198904365/cd63b467ff32f8730cae429a/CleanShot-2B2024-09-04-2Bat-2B22_55_01.gif?expires=1729610100&signature=f6f9b76123368c9fa2a320382ed252bf2d9c48336f06c0ee8c0b9d886a16cce5&req=dSEuHsB%2BmYJZXPMW1HO4zRXCYOkkpPb%2Fgs3r2grz9eOL8A%3D%3D%0A 6. You can also add other column values to the table, which is useful when transferring lead data from one table to another using the 'Write to Table' column. This setup can work independently, without the list feature configured in step 4. https://downloads.intercomcdn.com/i/o/1198904364/78c2e80597d41d589143e455/CleanShot-2B2024-09-04-2Bat-2B23_00_35.gif?expires=1729610100&signature=69ed293480c7b1fc5c23cb156563f0eefa8350d3066d261a96f36d5b1846c49f&req=dSEuHsB%2BmYJZXfMW1HO4zWjfjctBIpfJLP7nTaI26NnI0g%3D%3D%0A You're all set! You can now save and run your 'Write to Table' column.
Hey Bruno R. thanks for the detailed info and I can work with that. But for some reason, I need within the same table. Now I understand your point, that it would disrupt the structure of the current table. Still, wouldn't any formula or something work, to either duplicate or simply output those previous columns as blank while giving output for each person
Unfortunately, it's not possible to set this up within the same table. The only workaround would be to parse each lead’s information into individual columns, as shown in the screenshot you shared. However, keep in mind that this approach could potentially hit the column limit of the table.
Got it, Thanks!