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