is it possible to just copy a column from one table to another? and have the exact same settings
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."
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
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.