Clay Icon

Writing to Another Table: Manual Recreate or Duplicate Column Names?

Β·
Β·

When using the "Write to Other Table", do I need to manually recreate all the columns in the new sheet or can I just duplicate the column's names from the first sheet?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫢 Don't worry, only admins will be able to open your table πŸ˜‰

  • Avatar of Alex V.
    Alex V.
    Β·
    Β·

    Also, 2nd question, if I forget a column and I need to re-push all the rows, will the existing rows get updated with the missing data, or is it repushing the entire rows again so I will have duplicates in my new sheet?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey Alex! Yep, it's probably easier to duplicate an existing table and edit it so you can quickly map it out. It's something we have to look into to see if new columns could be created this way when mapping it out though. (will check with the team)

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    For the second question, yeah, unfortunately, it doesn't detect the existing record to update, so it will create a new one at the bottom. You can use a Lookup Record integration instead to pull other missing fields if that helps though

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Let me know if you run into any issues!

  • Avatar of Alex V.
    Alex V.
    Β·
    Β·

    Amazing thanks a lot Arturo O., let me know if it would be doable to automatically create the columns in the second sheet without having to do the matching