Migrating Columns and Configs Across Tables for Data Enrichment

·

is it possible to migrate columns & configs from one table to another? I have data on an existing table and need to change the architecture, and have my enrichment columns run on a different table but there's quite a few to remake

5 comments

Clay Team
APP
·
·
Hey Nick, thanks for reaching out!
Clay Team
APP
·
·
You can duplicate a table to keep the general structure and then make the smaller mods to that new copy, that way you'll keep the overall logic but without any data, you'll be able to import new records for that particular workflow once you're done or maybe a few to test your new logic out before adding more to enrich.Let me know if that was it!
Nick S.
·
·
Thanks Arturo. I prefer not to create a new table though, because there's a fair bit connected to the one that holds data right now, I just need the enrichment columns coupled with that data. How would you suggest I do that?
Clay Team
APP
·
·
Sorry for the delay, Nick! I'd probably duplicate the enrichment columns and have them run on that other logic or the corresponding formulas
Clay Team
APP
·
·
But overall, there's no way to copy single columns and paste them on another table with data included. If you duplicate a table, it just keeps the workflow with no data