Clay Icon

How can I copy rows from one table to another

·
·

How can I copy rows from one table to another

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You can copy rows from one table to another using our Write to Table integration. Here's how: 1. Click the "Add Enrichment" button in the top right corner of your page 2. Search for and select "Write to Table" in the search bar The Write to Table integration supports two main ways to transfer data: ** Column mapping: Transfer specific columns from one table to another while maintaining data alignment ** List mapping: Break down lists within cells into individual rows in the destination table Note that when you duplicate a table, only the header structure is copied by default. To transfer the actual data, you'll need to use the Write to Table integration to map your existing data fields to the corresponding columns in your new table.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Is that what you were looking for?

  • Avatar of Adam A.
    Adam A.
    ·
    ·

    Sam W. mapping can be a little difficult, let me know if you need any extra help and im happy to jump in

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Here are some tips to make mapping easier when using Write to Table: 1. For Column Mapping: • Ensure your destination table has clearly named columns • Use "/" to skip the list selection step when you're only copying columns • Match source columns to corresponding destination columns carefully 2. For List Mapping: • First identify which column contains your list data • Select the specific list properties you want to map to your new table columns 3. Helpful Settings: • Enable "Auto-update" if you want new rows to be automatically enriched when added • Use the "Only run if" condition to control when the integration runs based on specific data fields If you encounter any issues: ** Double-check that all columns and tables exist ** Verify that you're not writing to deleted columns * Make sure there are no conflicting data references between tables

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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