How to Add a Column and Copy Data Between Tables for Better Organization

what is the best way to add a column from one table and copy it to another table - - for context did a bunch of experiementation with the scrape and ai features and want to bring it to a new table with all my data

✅1

10 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Great question, Taylor! The Lookup Record would be the best way to do this if you have a matching value in both tables. Here's a video and our docs page for Lookup Record!
Taylor U.
·
·
Ah sorry this is not what i'm trying to do
Taylor U.
·
·
i don't wanto look up the record i want to like copy over the formulas etc
Taylor U.
·
·
i think i figured it out
Clay Team
APP
·
·
Ahh, I see. Makes sense now! Maybe you wanted to duplicate the workflow, or if it's a column you can save as a template that would also work
Taylor U.
·
·
okay yes that's exactly right
Clay Team
APP
·
·
Got it! Yep, usually duplicating tables is the best to keep and repeat a workflow, since it doesn't keep the data, allowing you to add fresh values.
Stavrianos S.
·
·
Arturo O. after I have duplicated a table, how do I trigger the same workflow for data currently in a csv file?
Clay Team
APP
·
·
Hey Stavrianos S., thanks for the inquiry!All that you would need to do is import the CSV file into the duplicated table and make sure that the necessary values for everything to run go to the corresponding columns. Let me know if you run into any issues!