Clay Icon

How to Copy Rows from One Table to Another in Excel

Β·
Β·

Hey everyone, I'm trying to copy from one master table of companies, only 5 rows to another table, how can I do this?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To copy 5 rows from one master table of companies to another table in Clay, you can use our "write to table" feature. Here's how: 1. In your source table, click on "Actions" > "Add Enrichment". 2. Search for and select "Write to Table". 3. Choose your destination table. 4. Map the columns you want to copy from the source to the destination table. 5. To limit it to 5 rows, use the "Only run if" condition. Set it to run only for the first 5 rows (e.g., "Row Number is less than or equal to 5"). This will transfer the data for the first 5 rows from your master table to the new table.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.