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?

✅

1

6 comments

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 😉
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?
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)
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
Clay Team
APP
·
·
Let me know if you run into any issues!
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