I would like to merge 2 CSVs based on a common value (such as ID). The second CSV would add a new column (not all new rows). I believe this is called a left join in database verbiage. Is this possible in Coda and if so, how to do?
In the “main” table, have a column with a formula like the following OtherTable.filter(commonValue=thisrow.commonValue).columnNeeded
Thanks for this Piet. Will try this out.