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

Copy a Column from One Table to Another with Settings Intact | Clay

Copy a Column from One Table to Another with Settings Intact

·Jun 04, 2025 08:32 AM·

is it possible to just copy a column from one table to another? and have the exact same settings

3 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, you can copy a column from one table to another using the "write to table" feature. This allows you to transfer specific columns while maintaining data alignment and consistency. To do this: 1. Click "Actions" → "Add Enrichment" 2. Search for "Write to Table" 3. Select your destination table 4. Enter "/" to skip list selection 5. Map the column you want to copy to the corresponding column in the destination table You can also duplicate a column within the same table by right-clicking it and selecting "Duplicate."
Sources: Write to Other Table | Documentation | Clay University Rename, Pin, Duplicate, Delete Column Write to Other Table | Documentation | Clay University
Maxim K.
·
·
does it only work for text data? just tried it with a lookup column and it only created a text column with no data in the other table
Channeled
APP
·
·
The write to table feature works with various data types, not just text. When copying a lookup column, you need to map it correctly in the destination table. To properly copy a lookup column: 1. Make sure the destination table has the same column type (lookup) 2. Use "Add Enrichment" → "Write to Table" 3. Select your destination table 4. Enter "/" to skip list selection 5. Map your lookup column to the corresponding lookup column in the destination table If you're seeing empty text columns, check that both columns are the same type before mapping.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University