You have two options to achieve this: 1. Use the Write to Table integration:
• Click "Add Enrichment"
• Search for and select "Write to Table"
• Choose your destination table
• Skip the list selection by entering "/"
• Map your source columns to the destination table columns
2. Create a merged column:
• Click "Add Column" > "Merge columns"
• Input a formula to combine your two columnsThe Write to Table method is ideal if you want to maintain separate tables, while the merge columns option is better for combining data within the same table.
Sources:Write to Table - Clay UniversityHide, Re-order, Sort, Filter, Merge Columns
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
