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?

2 comments

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
Channeled
APP
·
·
Hi Tarun M.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: