Is it possible to do joins like a left join

1

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?

2

HI Stephen

In the “main” table, have a column with a formula like the following OtherTable.filter(commonValue=thisrow.commonValue).columnNeeded

Regards
Piet

3

Thanks for this Piet. Will try this out.