Skip to main content

Hi there,


I am currently working on a project to summarize data across multiple bases. I have set up share links so that in this single base I have a share table from each of my other bases. Each of these tables is laid out the same way

[Name] [Amount] [Date Purchased] [Store Purchased]


I want to combine these records from these multiple tables into one big table e.g

If table 1 looks like:

[Name] [Amount] [Date Purchased] [Store Purchased]

Aaron, 10, 10/11, New York

Abby, 34, 10/12, New York

And table 2 looks like:

[Name] [Amount] [Date Purchased] [Store Purchased]

Aaron, 21, 10/30, Los Angeles

Anna, 34, 10/31, Los Angeles


Then my final table would look like

[Name] [Amount] [Date Purchased] [Store Purchased]

Aaron, 10, 10/11, New York

Abby, 34, 10/12, New York

Aaron, 21, 10/30, Los Angeles

Anna, 34, 10/31, Los Angeles


Is this possible? I am hoping to have these bases to be separate and then converge instead of having all purchases on one table and then separating them into new bases.


Thanks!

Hey @Wyeth_Coulter,


Welcome to the Airtable community 👋


You are trying to combine several tables that are each structured the same way into one big table.


Unfortunately, you can’t do this in Airtable easily.


You could export each table as a CSV and combine them in another application like Google Sheets or Excel.


Or, if you know SQL - this is very easy to do as a UNION with our product - Sync Inc.


You can try Sync Inc out completely for free → syncinc.so


Here is a quick blog post that also explains how to do the UNION with some sample code.




If you need any support, feel free to shoot me a message. I am around and happy to help more.


@Wyeth_Coulter, I am trying to do this exact same thing - what did you end up doing? I wrote an automation so that each new row that syncs from the separate base to the tab in the “master” base will copy over into a new tab. In other words, an automation per synced tab to copy the row over into a master tab. This isn’t very sustainable… so am looking for a solution like you.


Hi @Megan_Sellheim, sadly I was not able to achieve what I wanted to do. Just ended up creating a base with all the information and then making different views


Hi @Megan_Sellheim, sadly I was not able to achieve what I wanted to do. Just ended up creating a base with all the information and then making different views


‘’@megan_sellheim

Found it!



‘’@megan_sellheim

Found it!




This is exactly what I was looking for, thank you for sharing this!


Reply