I want to write into another table, for each rows, all the items in a collection, that belongs to a parent collection (see pic below) use case: I have owler funding, each funding brings back the investor in that round. I want all those, if 3 investor into each of 4 funding, I want to write 12 investors into another table
You can use the Write to Table feature to handle this "one-to-many" data relationship. Here's how to map your funding rounds' investors to a new table: 1. Add Write to Table enrichment: โข Click "Add Enrichment" โข Search for and select "Write to Table" 2. Set up the mapping: โข Select your Clay account โข Choose your destination table โข Select the column containing your investor lists โข Map the investor properties to your new table columnsThis process is specifically designed for handling "1 to many" relationships like your case where one funding round has multiple investors. Each investor from your funding rounds will be written as a separate row in the destination table.You can optionally configure auto-update to automatically process new entries and set conditions for when the enrichment should run. Sources: Write to table integration overview | Documentation | Clay University Write to Table [Clay 101] - Clay University
Is that what you were looking for?
Hi Esteban L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Thank you so much for sharing your feedback Esteban L.!