Clay Icon

How do I add outputs from one table to another in the same workbook?

Β·
Β·

How do I add outputs from one table to another in the same workbook?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    You can transfer data between tables in your workbook using the Write to Table integration. Here's how: 1. Select your Clay account (if not already connected) 2. Choose your destination table within your workbook 3. You have two options for transferring data: β€’ Column mapping: Copy specific columns from one table to another β€’ List mapping: Map individual items from a list into separate rows in the destination table Optional settings include: ** Auto-update: Automatically enriches new rows when added ** Conditional running: Set specific conditions for when the transfer occurs Note: There's a limit of 10 tables that can be connected via Write to Table, and data can only flow in a linear direction (A β†’ B β†’ C, not A β†’ B β†’ A). After transferring the data, you can combine information from different columns using the Merge Columns feature by clicking Add Column and selecting Merge Columns.

  • Avatar of Joel M.
    Joel M.
    Β·
    Β·

    is there another option?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Yes, you can use the Import feature to add data from one table to another. Here's how: 1. Open your destination table 2. Click "Actions" in the top-right menu 3. Select "Import" 4. In the "Add Source" panel, you can select and configure your source table 5. Review the settings and import the data into your existing table

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·