Clay Icon

Replicating Two Columns into One in a New Table

Ā·
Ā·

How can I replicate this in a new table? I wanna collect the results from 2 columns in one column

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    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 University Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    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 02 Support.