Moving Columns from One Clay Table to Another: Tips and Tricks

Hey Karen R. - can you clarify this one a bit? Are you trying to move columns from one Clay table to a new empty table?

Or do you have another table already built, and you want to pull that data in?

Hey Augustin, in these cases, you can use Write to table or the Lookup Record integration depending on the situation. Write to table would help you push data from columns and create new rows in a new or existing table. The Lookup would allow you to find and establish a connection between two tables and a specific value, which you can then pull in associated records in the table you use it in.Write to table https://www.loom.com/share/841cc9c009194f1688bbd134b3e4f388Lookup Record-> Here's a video

If it's something else, like copying/pasting columns from one place to another, like if it were Google Sheets or Excel, that's not currently possible, but you can duplicate a table to keep the same workflow as a template and add new data to it.