Export data from two different tables

App Development
1

Hi seems like a simple thing but i’m struggling a bit. How do I export 1 cvs sheet containing data from two tables. Seen a post 2 years ago where Moe made a solution for a similar thing, but it made 2 separate sheets.

Any anyone help?

2

Are the columns in both tables identical? Technically I’m not seeing how this is possible. You’ll end up having all the columns added but the records will not align.

Column Structure Differences:

  • When combining data from two tables into one CSV file, you have to consider whether the columns in both tables are identical or different.
  • If the columns are identical, you could technically combine them in a CSV, appending records from one table after the other. However, this would still represent data sequentially, not “joined” in any meaningful way.
  • If the columns are different, the resulting CSV would have all the columns from both tables, which could cause confusion. Each row from one table might have empty cells for columns that don’t apply, creating a misalignment.

Think of it this way: If you were to merge two tables with different structures, you would end up with a CSV where some columns are only relevant to one table, leaving the corresponding cells blank for the records of the other table.

Here’s a simple example:

  • Table 1 (Customer Info): Customer ID, Name, Email
  • Table 2 (Order Info): Order ID, Customer ID, Order Date, Amount
Customer ID, Name, Email, Order ID, Order Date, Amount
1, John Doe, john@example.com, , , 
2, Jane Smith, jane@example.com, , , 
, , , 101, 2024-11-01, 150.00
, , , 102, 2024-11-03, 250.00

As you can see, there’s no logical alignment between customer and order data in a single row unless you have a specific “join” relationship.

3

Hi @moe , thanks for the reply.

I think didn’t describe it well enough… I have different data from related records that I need in 1 single sheet. Some of the data in the 2 tables are the same (as I need them for referencing in make.com etc).

In simple terms, I just need 1 excel sheet to show various data of 1 record which is split in 2 (or more) tables. In my case, the USER (user table) and their connected ‘Properties’ in the ‘Property’ tables

4

@moe Is there any response from the above can you help ?

I need to export the Users table, and the connected data for those users from a ‘Criterias’ table in 1 single sheet

5

Could you just create a page with a table view and add the fields from both tables and add an export option. I do this for a report that shows Queries and related Quotes on the same row of the export. These are two separate tables

6

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.