I am trying to copy a worksheet/table to a new clean one. This way I can keep my old columns and work as a reference but also clean up the new one so i don't have all the mess. I tried duplicate table from the table itself. It copies it, but there are no rows?
When you duplicate a table in Clay, only the header structure is copied, not the data. To copy both structure and data to a new table, you have two options: 1. Use the "write to table" integration: • Click "Add Enrichment" in the top right corner • Search for "Write to Table" • Select your destination table • Map your existing columns to the new table 2. Use "Send table data" feature: • Go to "Actions" → "Send table data" • Select your destination table • Choose "Send row" and select which columns to transfer • Click "Save" Both methods will transfer your data along with the structure.
Send table data doesnt give me the option to move columns that are AI prompts.
To copy a table with AI prompt columns, use the "write to table" integration: 1. Click "Add Enrichment" in the top right corner 2. Search for "Write to Table" 3. Select your destination table 4. Enter "/" to skip list selection 5. Map all your columns (including AI prompts) to the new table 6. Optional: Configure auto-update settings This method transfers all data and column structures, including AI prompts, unlike the "Send table data" feature which has limitations with AI columns.
Hey Josh, I totally understand the challenge you're facing. Currently, Clay doesn’t support an exact duplication of a table with data intact as it appears in its current state. When you duplicate a table in Clay, it essentially creates a template copy, preserving all column configurations such as prompts, formulas, HTTP API setups, write-to-table actions, and conditions. This saves you the effort of rebuilding the structure from scratch. However, to replicate the data itself, you'll need to manually re-run any data source integrations. For instance, if your original table pulled data from another table or executed a search (e.g., company or people search), you'll need to re-trigger those queries. Similarly, any enrichment or export columns will need to be re-executed to recreate the original table’s contents. I know this requires a few extra steps, but that’s how duplication currently functions in Clay. If this feels limiting, I’d recommend submitting a feature request in the Feedback and Requests channel, I'm sure the team would appreciate your input. Best, Khush
When you duplicate a table in Clay, only the header structure is copied, not the data. To create an exact copy with all data and AI prompt columns: 1. Use the "write to table" integration: • Click "Add Enrichment" in the top right • Search for "Write to Table" • Select your destination table • Enter "/" to skip list selection • Map all columns (including AI prompts) to the new table This method transfers both your data and column structures completely, preserving all AI prompt columns.