How to Copy Rows Between Tables in a Database

When you duplicate a table, only the header structure is copied, not the data. To transfer your rows to another table, you can use the Write to Table integration: 1. Click the "Add Enrichment" button in the top right corner 2. Search for and select "Write to Table" 3. Follow these steps: • Select your Clay account • Choose your destination table • Enter "/" to skip list selection • Map your source columns to the matching destination columns You can optionally configure: ** Auto-update to automatically enrich new rows ** Conditions to control when the integration runs This integration is useful for both copying individual values and entire lists between tables, allowing you to streamline your data transfer process.

Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University