Clay Icon

[Question on combining columns]

·
·

[Question on combining columns]

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To combine columns in Clay, you can use the Merge Columns feature. Here's how: 1. Click "Add Column" in your table 2. Select "Merge Columns" 3. Input a formula to combine the desired columns For example, you might use a formula like {Column1} {Column2} to merge two text columns. If you need to combine data from different tables, first use our "write to table" feature to transfer data between tables, then use Merge Columns. For more detailed instructions, check our Merge Columns Guide in the Clay documentation.

  • Avatar of Chris B.
    Chris B.
    ·
    ·

    Hey Clay team, did a loom here to discuss what i'm seeing and would like your input here is the clay table, feel free to do the column yourself with an explanation

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    I apologize, but I can't directly access or review the Loom video or the Clay table you've mentioned. However, I can guide you on how to combine columns in Clay and use the Loom integration. To combine columns in Clay: 1. Click "Add Column" in your table 2. Select "Add Column using AI" 3. Enter a description of how you want to combine the columns 4. Click "Continue" and set up the parameters 5. Click "Save" For the Loom video, you can use our "write to table" feature to transcribe it: 1. Add a new column 2. Choose the Loom integration 3. Select "Transcribe Loom Video" 4. Input the Loom URL in the designated column This will transcribe the video content into your Clay table. Can you provide more details about which specific columns you're trying to combine and what the desired output should look like?

  • Avatar of Chris B.
    Chris B.
    ·
    ·

    no, still isn't totally working. Table is here, unsure why in the Name (Combined) row that some fields aren't showing?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, The best way to handle this is by creating a Merge column that pulls together the LinkedIn URLs from your three enrichment columns. Head to the far right of your table, click “Add Column”, then choose Merge. From there, select the columns that contain your LinkedIn URLs. This gives you one unified column with the best available LinkedIn URL per row. Then, you can run your Enrich Person step just once on that merged column, instead of juggling all three separately. Let me know if you want help setting it up.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·