Clay Icon

Is there a way to merge two table in a workbook?

Β·
Β·

Is there a way to merge two table in a workbook?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    You can merge tables using the "Write to Table" integration. Here's how: 1. Click "Add Enrichment" in the top right corner of your page 2. Search for and select "Write to Table" integration 3. Select your destination table within your workbook 4. Map your columns: β€’ Skip the list selection by entering "/" β€’ Select which columns from your source table you want to copy β€’ Match them to the corresponding columns in your destination tableYou can optionally configure settings like: ** Auto-update to automatically enrich new rows ** Conditions to control when the integration runsThis integration allows you to transfer data between Clay tables, whether it's single values, lists, or objects. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Was that helpful?

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    Hey there, thanks for reaching out! ☺️ To merge two tables in a workbook, you can use the "Write to Table" feature. This allows you to consolidate data from multiple tables into a single table efficiently. Here’s how you can do it: 1. Create a Master Table: Set up a new table where all your data will be merged. 2. Use the Write to Table Integration: Add this integration to each of the tables you want to merge. This will enable you to send data from these tables to your Master Table. 3. Configure the Integration: Ensure that the integration is set up to write data from each source table to the Master Table. 4. Dedupe and Manage Data: Once the data is in the Master Table, you can add a deduplication filter to manage duplicates automatically. For more detailed guidance, you can refer to the following resources: * Write to Table Overview * Clay 101 Guide If there's anything else I can assist you with, please let me know! 😊 Have a great Wednesday, Daniel

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here.If you still need some help, just reply back here and someone from our team will be in touch!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

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