Need Help Duplicating Prod Table with All Data and Actions

Herve S. · 2025-09-26 15:20:34.154884+00

Hi there, for making a demo, I want to duplicate a prod table with all its 30+ actions columns (AI agent, waterfall, ...), and all data and formats. I struggled following Sculptor instructions because I always end-up in a duplicate table where data is there but actions columns are gone or actions columns are there but data cannot be imported (import failed as it re-creates new duplicate columns). I don't want many methods that don't work as Sculptor keeps on suggesting, I just want one as simple as possible that works

Need Help Duplicating Prod Table with All Data and Actions | Clay

6 comments

· Sorted by Oldest

Hunain F.
·
·
Hi - Herve S. To duplicate a production table in Clay with all your 30+ action columns and data, the simplest reliable method is this: First, duplicate the table structure with actions. In Clay, open your production table, click the “⋮” menu (More options), then choose Duplicate Table and select “With Actions.” This gives you a new table that has all the AI agent, waterfall, and enrichment columns set up, but no data. Next, export your production table as a CSV, making sure to include all raw input columns, not just enrichment ones. Then, import that CSV into your duplicated table. When importing, map the input columns carefully to the existing ones. Clay will automatically re-run the action columns on the imported data so they populate correctly, instead of creating duplicate columns. The issue you were running into missing actions or failed imports comes from importing into a table that didn’t already have the matching action columns. By duplicating the table with actions first, you preserve the pipeline, and then just feed in the raw data again. This way you’ll have a complete demo table with all 30+ actions intact and data populated just like your production version. If you still haven’t been able to make the demo, DM me and I’ll create it for you.
🎉1
Kabeer A.
·
·
The simplest way to fully duplicate a table (data + all action columns intact) is to use “Duplicate Table with Columns” from the table menu, then export/import the data as CSV if you need the rows too. Importing into a new table usually re-creates columns, so the trick is: first duplicate structure, then paste/append the data into it. That way your AI/waterfall columns stay linked.
Herve S.
·
·
Thx Hunain F. I've redone again but when I mapped all columns in the csv import step, it looks good, but somehow Clay adds 15% more columns (probably because of the many columns) and import process failed. PS: it seems I have a different UI as “⋮” menu and Duplicate Table and select “With Actions.” don't exist for me.
Herve S.
·
·
Kabeer A. after duplicate table, doing a copy/ paste of rows was successful but all AI agents/ Enrichment/ Waterfall columns should be re-run, as actual data is not pasted, so not worth spending credits twice again for a demo purpose. It feels all those workarounds don't do the job with minimal value, so back to run demo on the original table. Maybe Clay will introduce a new capability to fix that. 🤔
Hunain F.
·
·
Herve S. So if you want then I can do this for you.
Shafqat H.
·
·
Copy the table as a new workspace export/import isn’t enough use Clay’s Duplicate with Actions option from the table menu, then ‘Export & Import Data’ back into that duplicate to keep every action column intact

Hunain F.
·
·
Hi - Herve S. To duplicate a production table in Clay with all your 30+ action columns and data, the simplest reliable method is this: First, duplicate the table structure with actions. In Clay, open your production table, click the “⋮” menu (More options), then choose Duplicate Table and select “With Actions.” This gives you a new table that has all the AI agent, waterfall, and enrichment columns set up, but no data. Next, export your production table as a CSV, making sure to include all raw input columns, not just enrichment ones. Then, import that CSV into your duplicated table. When importing, map the input columns carefully to the existing ones. Clay will automatically re-run the action columns on the imported data so they populate correctly, instead of creating duplicate columns. The issue you were running into missing actions or failed imports comes from importing into a table that didn’t already have the matching action columns. By duplicating the table with actions first, you preserve the pipeline, and then just feed in the raw data again. This way you’ll have a complete demo table with all 30+ actions intact and data populated just like your production version. If you still haven’t been able to make the demo, DM me and I’ll create it for you.
🎉1
Kabeer A.
·
·
The simplest way to fully duplicate a table (data + all action columns intact) is to use “Duplicate Table with Columns” from the table menu, then export/import the data as CSV if you need the rows too. Importing into a new table usually re-creates columns, so the trick is: first duplicate structure, then paste/append the data into it. That way your AI/waterfall columns stay linked.
Herve S.
·
·
Thx Hunain F. I've redone again but when I mapped all columns in the csv import step, it looks good, but somehow Clay adds 15% more columns (probably because of the many columns) and import process failed. PS: it seems I have a different UI as “⋮” menu and Duplicate Table and select “With Actions.” don't exist for me.
Herve S.
·
·
Kabeer A. after duplicate table, doing a copy/ paste of rows was successful but all AI agents/ Enrichment/ Waterfall columns should be re-run, as actual data is not pasted, so not worth spending credits twice again for a demo purpose. It feels all those workarounds don't do the job with minimal value, so back to run demo on the original table. Maybe Clay will introduce a new capability to fix that. 🤔
Hunain F.
·
·
Herve S. So if you want then I can do this for you.
Shafqat H.
·
·
Copy the table as a new workspace export/import isn’t enough use Clay’s Duplicate with Actions option from the table menu, then ‘Export & Import Data’ back into that duplicate to keep every action column intact