Merge Two or More Tables into One

Hello, I’m new to Coda.io and still learning how to use the platform. I’d like to know if it’s possible to merge two tables into one using formulas.

For example, I have two employee tables, both with the same columns: Name, Position, and Department. My goal is to create a third table that combines the data from these two but only displays two columns: Name and Company.

Name Column: To show the person’s name.

Company Column: To indicate which company they belong to.

It would be similar to a MERGE TABLE function in other tools.

Is this possible in Coda.io? If so, could you guide me on how to achieve it?

HI @Jhorman,

Welcome to Coda, and welcome to the community!

What you are asking is possible, but cumbersome.

The recommended approach would be to have a single table, and then split the information into different views.

3 Likes

Hello @Jhorman

You can use the Merge Table Pack or Formula Tables Pack for a more dynamic solution. However, if you simply want to copy data from two tables into one, you can achieve this using formulas and a button.

Best Regards,
Arnhold

2 Likes

Hi @Jhorman ,

I’m assuming you don’t necessarily want to copy the data, hence having it duplicated, but to be able to visualize in a single view data from different tables.

This can be achieived in many ways using ‘Relations’ in Coda, please take a look at this link and if you still have questions, don’t hesitate to follow up on this thread: Connect tables with relation columns | Coda Help Center

Hope this helps,

Pablo

2 Likes