Clay Icon

Copying Rows Between Database Tables Explained

ยท
ยท

Can we copy a row from 1 table to another table? (not duplicate in the same table)

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    Yes, write to other table function

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can transfer rows from one table to another 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 Clay account (you'll need your API key if not already set up) 4. Choose the destination table you want to copy the row to 5. Enter "/" to skip the list selection 6. Map the columns from your source table to the matching columns in the destination tableYou can optionally configure auto-update to automatically enrich new rows and set conditions for when the integration should run.The Write to Table action supports transferring lists, single values, or objects between Clay tables, giving you flexibility in how you move your data. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Excellent! I'm glad I could assist you with that. I'm here if you need any further help.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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

  • Avatar of Rashi A.
    Rashi A.
    ยท
    ยท

    I mean in the same workbook and another table

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can copy rows between tables in the same workbook 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 Clay account (you'll need your API key if not already set up) 4. Choose the destination table within your workbook 5. Enter "/" to skip the list selection 6. Map the columns from your source table to the matching columns in the destination tableYou can optionally configure auto-update to automatically enrich new rows and set conditions for when the integration should run. Source: Write to table integration overview | Documentation | Clay University

  • Avatar of Rashi A.
    Rashi A.
    ยท
    ยท

    Will this enrichment charge clay credits?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    No, the Write to Table integration is a credit-free way to transfer data between tables. It's a basic functionality that allows you to copy data from one table to another within Clay, whether you're mapping individual values, entire columns, or lists. Sources: Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    I'm delighted to hear that! I'm always here if you need any further assistance.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Great! I'm glad I could help. I'm here if you have any more questions.