I see quite a few discussions about how to merge two tables, and the responses all seem to point out that this is the incorrect paradigm to think about, however the answers all seem to be coming from the direction of creating the source data as one database, then splitting views downstream. I need to do this in a different direction:
I have data coming from two different departments’ living pipelines: One in Asana for recruiting candidates, and one in google sheets for hired employees. Does anyone have any advice on how to merge these into one table (let’s assume the data is all laid out exactly the same)?
To be clear, yes, I can manually copy entries and manually build a unified database, obviously I’m striving for some degree of automation here. Is this doable at all within Coda, or am I forced to merge pre-coda?