Ivan D.

Hi Mayato, so say we have 2 identical tables (in terms of column names and data type) with different data in both I’d like to combine both, so send the data from table A to table B Then, instead of creating a new column for e.g. “first name”, i want to map the first names to the already existing first name column Unfortunately, if i do that, the original data in the column will be deleted Does that make sense?

Okay yeah, so i know that it works with empty tables. Question is, how do i map one table to another when there’s data in the target table already?

i haven't found that option, can you pls send me a screenshot of where that is?

https://app.clay.com/workspaces/641338/workbooks/wb_0t8c0j1jXpT8ceTm6XV/tables/t_0t8c0jxQVgEAryyKZAx/views/gv_0t8c0jxBPSj5yExnVNA

thanks

Clay S. no - you're contradicting yourself.

And this is strange, because the other day i did the exact same thing but it worked well - not sure what's different now

If i try to map to existing columns it shows an error saying that the existing values will be overwritten