Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Migrating Columns and Configs Across Tables for Data Enrichment | Clay

Migrating Columns and Configs Across Tables for Data Enrichment

·Feb 19, 2024 05:35 PM·

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

· Sorted by Oldest

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