.png){kind=logo}
Generating Multiple Rows in a Table from Function Results
hey support, when i have two or more people in this function ran successfully, how can i generate 2 or more rows in another table? The current view I have is only showing the first result.
hey support, when i have two or more people in this function ran successfully, how can i generate 2 or more rows in another table? The current view I have is only showing the first result.
Hi Rodolfo Y.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Hey there - we're having a bit of trouble with our support tooling and closed this conversation out preemptively. Reopening it here and someone from our team will get back to you soon!
To generate multiple rows in another table, you should use the "Lookup Multiple Rows in Other Table" action instead of a single-row lookup. Here's how to handle multiple results: 1. Use the "Write to Other Table" action, which supports writing lists and multiple values. 2. When setting up your lookup: • Configure the action to search for multiple matching records • Make sure you're not limiting the results to a single row • Use the appropriate column mappings to transfer all the data you needNote that for better performance, you should only use the multiple rows lookup when you actually need to retrieve multiple records. If you only need single-row lookups, use the "Lookup Single Row in Other Table" action instead. Sources: Lookup Multiple Rows in Other Table with Clay Write to Other Table with Clay Labs
Hi Rodolfo, thanks for reaching out. Taking a look at this now!
You can set this up through our write to other table integration, here's how: 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=1739288700&signature=8d9917d63de8cb8d15a856a88396f80606cdb48c89410e1a77da4c570d644460&req=dSEuHsB%2BmYJZWPMW1HO4zUOGxNVGfDLb3XP6pls40EU4Dw%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=1739288700&signature=7c49122b84a91c5c20b617519e7af06f5537f7a0e7ac0f01d6fa0991d6756cf1&req=dSEuHsB%2BmYJZW%2FMW1HO4zeoz8kw4yLePqPOJ9fQhK2l%2Fkw%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=1739288700&signature=b8a2fdfaf39d0c7df86eb456a59a1ef0ef2b8a688b07c1db00c77db27da62f7c&req=dSEuHsB%2BmYJZWvMW1HO4zT205zmCz1kYR2g4Gfhv9uUnEQ%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=1739288700&signature=8575545cc553bdaefe62f73cd225a8806f63d135856bb1c1f798053e0a4b01c2&req=dSEuHsB%2BmYJZXPMW1HO4zRXCYekgrf75gs3r2grz9eN9%2FQ%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=1739288700&signature=3b2029dbfa61ee428a927e761e26e625a5108f2ece2ec58db6c35d3dd95f83b3&req=dSEuHsB%2BmYJZXfMW1HO4zWjfjMtFK5%2FPLP7nTaI26NmC9g%3D%3D%0A You're all set! You can now save and run your 'Write to Table' column.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.