Clay Icon

Steps to Transfer and Update Columns Between Two People Tables

ยท
ยท

Hi, I'm having trouble with the "write to table" functionality. I have two fully enriched "people" tables, but some of the enriched columns differ between the two tables. I want to move the relevant columns from one table to the other and also update the missing data in the older table with the enriched data from the newer table. Could you please help outline the steps to accomplish this?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use the Write to Table feature to merge and update your people tables. Here's how:1. First, select "Add Enrichment" and choose "Write to Table" from the search bar. 2. Choose your destination table (the table you want to write the data into). 3. Skip the list selection step by entering "/" since you're doing column mapping. 4. Map the columns from your source table to the matching columns in your destination table. You can select which specific columns you want to transfer. 5. Enable "Auto-update" if you want new rows to be automatically enriched when added.This process is particularly useful for managing "one-to-many" data relationships and maintaining consistent data across different tables. Sources: Write to Table - Clay University Write to Table [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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