Best Way to Transfer 36 Records from One Cell to Another Table

·

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?

4 comments

Channeled
APP
·
·
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.
Sources: Write to Other Table | Documentation | Clay University Send table data | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Send table data | Documentation | Clay University
Eishan D.
·
·
https://app.clay.com/workspaces/42687/workbooks/wb_0swokwdDxayj64Ki4BC/tables/t_0swokwyrn9aBn9uz6Rm/views/gv_0swokwyjhbFieDUK4hN
Eishan D.
·
·
more context
Bruno R.
·
·
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:
(485 kB)
Let me know if this helps!