Moving Contents When Duplicating a Table in SQL

Esther E.

Clay S. Duplicating a table doesn't move its contents, how can I move the content as well?

10 comments

Clay
APP
·
·
You're correct - duplicating a table only copies the structure, not the data. To move content to your duplicated table, use the "write to table" feature: 1. Click "Add Enrichment" in the top right corner 2. Search for "Write to Table" and select it 3. Map your existing data fields to the corresponding columns in your new table Alternatively, you can use "Send table data" by clicking Actions → Send table data, then selecting your destination table and choosing which columns to transfer.
Sources: Table management settings | Documentation | Clay University Table management settings | Documentation | Clay University Send table data | Documentation | Clay University Write to Other Table | Documentation | Clay University
Channeled
APP
·
·
Clay
APP
·
·
Thank you so much for sharing your feedback Esther E.!
Abdul S.
·
·
Hi Esther you're right, duplicating a table only copies the structure, not the data to move the content as well, use the Write to Table enrichment just follow these steps:
1.
Click Add Enrichment
2.
Search and select Write to Table
3.
Map the fields from your current table to the new one
4.
Run the enrichment
This will transfer all your data into the duplicated table lemme know if you’d like help setting it up
Clay
APP
·
·
Thank you so much for sharing your feedback Abdul S.!
Clay
APP
·
·
Thank you so much for sharing your feedback Abdul S.!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Shoaib R.
·
·
Esther E. I always prefer to download CSV and reupload it in a new table less hassle faster execution, let me know your thoughts?
Esther E.
·
·
Great!!! Thanks for sharing. I feel that will be easier too... Shoaib R.
1
Clay
APP
·
·
Thank you so much for sharing your feedback Esther E.!

Moving Contents When Duplicating a Table in SQL | Clay