Clay Icon
Join the Community
02 Support

How to Duplicate a Table and Preserve Data

Avatar of Ian M.Ian M.
·
·

Question "Duplicate Table" duplicates the structure and logic - which is super useful How does one do "Duplicate Table" that ALSO duplicates the data with it?

1 comment

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Great question! That's complicated to achieve from an engineering perspective because you'd likely duplicate enrichments columns, the way data is stored in them involves a unique API call. If data were to be duplicated, it would likely re-run these because it would consider them new calls in that table. Best way to get a copy of the data is to download the CSV and import it into the new one or use other tools like write to table or lookup to pull the data over. Of course, you could still run into the auto-enrichment issue, so just a heads up and to keep in mind.