Clay Icon

How to Copy and Paste a Column Without Showing Undefined Values

ยท
ยท

Am I able to copy and paste a column without it saying undefined in the blanks?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, you can duplicate columns in Clay using two methods:1. Quick column duplication: โ€ข Right-click the column you want to duplicate โ€ข Select "Duplicate" from the menu 2. Using Write to Table integration: โ€ข Click "Add Enrichment" in the top right corner โ€ข Search for and select "Write to Table" โ€ข Map the specific column you want to copy to the destination table โ€ข This method helps ensure data consistency and reduces manual entry Sources: Write to Table - Clay University Rename, Pin, Duplicate, Delete Column

  • Avatar of James Z.
    James Z.
    ยท
    ยท

    I am using an existing column to write information to. Merging existing data while over writing blanks of new data.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To transfer and merge data while preserving existing information, you can use the Write to Table integration. Here's how:1. Click "Add Enrichment" in the top right corner 2. Search for and select "Write to Table" 3. Select your destination table 4. Map your source columns to the corresponding destination columns 5. In the run settings, enable "Auto-update" if you want new rows to be automatically enrichedWhen using Write to Table, you can transfer your existing data fields to the corresponding columns in your new table while maintaining the current information. Source: Write to Table - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi James Z.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: