I have a company data table that is looking up multiple rows in people data tables -- what's the best way to write 36 records from one cell into another table?
To write 36 records from one cell in your company data table into another table, you should use the "write to table" feature with the "Send row for each item in a list" option. Here's how to set it up: 1. Select your Clay account 2. Choose the destination table (ideally within your current workbook) 3. Select the column containing your list of 36 records 4. Map the list data to columns in your new table 5. (Optional) Configure run settings like auto-update This approach is perfect for flattening lists - it will turn each item in your list into its own separate row in the destination table. Keep in mind there's a maximum of 10 connected tables (including across workbooks), and data can only flow in a linear direction.
more context
Hey there, thanks for your message! Writing your records will be indeed the only way to go here, but I suggest that you test our "send table data" action, which has recently been released and should allow you to select records for each row more seamlessly:
Let me know if this helps!