Clay Icon

Steps to Merge and Update Data 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 someone please help outline the steps to accomplish this?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Yes, we have two ways of doing this: 1. Write to Table: You can send data into a new table using the “write to table” option. This is great for sending lists of objects, individual values, or both. For example, if you have an enrichment with a list of multiple objects, you would select the “write to table list” option. You can also add other values to match that are in this table but not as a list. 2. Lookup: If you want to add more information that you already found from a previous table to the current data you have (e.g., matching domains), then “lookup” is the best option. This allows you to call matching data into one table. For faster replies on issues I would post in 02 Support

  • Avatar of Tarun M.
    Tarun M.
    ·
    ·

    Thanks bo I will however create a loom video to explain the challenge i am facing perhaps then you’ll be able to help me out better

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Can you post it in 02 Support ? 🙂

  • Avatar of Tarun M.
    Tarun M.
    ·
    ·

    Sure will do