.png){kind=logo}
Copying Rows Between Database Tables Explained
Can we copy a row from 1 table to another table? (not duplicate in the same table)
Can we copy a row from 1 table to another table? (not duplicate in the same table)
Yes, write to other table function
You can transfer rows from one table to another using the Write to Table integration. Here's how: 1. Click "Add Enrichment" in the top right corner of your page 2. Search for and select "Write to Table" integration 3. Select your Clay account (you'll need your API key if not already set up) 4. Choose the destination table you want to copy the row to 5. Enter "/" to skip the list selection 6. Map the columns from your source table to the matching columns in the destination tableYou can optionally configure auto-update to automatically enrich new rows and set conditions for when the integration should run.The Write to Table action supports transferring lists, single values, or objects between Clay tables, giving you flexibility in how you move your data. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University
Excellent! I'm glad I could assist you with that. I'm here if you need any further help.
I mean in the same workbook and another table
You can copy rows between tables in the same workbook using the Write to Table integration. Here's how: 1. Click "Add Enrichment" in the top right corner of your page 2. Search for and select "Write to Table" integration 3. Select your Clay account (you'll need your API key if not already set up) 4. Choose the destination table within your workbook 5. Enter "/" to skip the list selection 6. Map the columns from your source table to the matching columns in the destination tableYou can optionally configure auto-update to automatically enrich new rows and set conditions for when the integration should run. Source: Write to table integration overview | Documentation | Clay University
Will this enrichment charge clay credits?
No, the Write to Table integration is a credit-free way to transfer data between tables. It's a basic functionality that allows you to copy data from one table to another within Clay, whether you're mapping individual values, entire columns, or lists. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
I'm delighted to hear that! I'm always here if you need any further assistance.
Great! I'm glad I could help. I'm here if you have any more questions.