Combining two tables together into one

2

Hello @Harry_Roper!
The problem is that for Coda those are 2 different tables, even if they have the same column names. So when you try to get CurrentValue.Name Coda can only reference the first table but not the second. That’s why you only get empty values when it starts importing the second table.

For this to work you’d have to write the same formula referencing each table separately, that means removing the list combine and use only one table on each formula, as follows:

ForEach(
  [Odaia Tasks],
  AddRow(
    [All Workspace Tasks],
    [All Workspace Tasks].Name,
    CurrentValue.Name
  )
)

ForEach(
  [Movertis Tasks],
  AddRow(
    [All Workspace Tasks],
    [All Workspace Tasks].Name,
    CurrentValue.Name
  )
)

Let me know if this helps or if you have other questions. I’m happy to help

There are also other options, like this pack someone made that does exactly this.
Launched: Merge Table Pack - Making Packs - Coda Maker Community

3 Likes