append/calculate two different tables

[sbenzaquen]

Hi,

I have two data tables that I would like to aggregate. They have different column names and orders. 

Could you please let me know how would you aggregate both tables?

For instance:

• Table 1 has the following columns: Client name, client country, supplier name, supplier country
• table 2 has the following columns: Supplier name, Supplier Country

I want to create an aggregated table that would have Supplier Name and Supplier country data from both tables.

Thank you in advance.

Kind regards,

Salvador

[amitchandak · Accepted solution]

@sbenzaquen ,

Try like this example

a new table 

Distinct(union (

Summarize(Table1,[Supplier name], [Supplier Country]),

Summarize(Table2,[Supplier name], [Supplier Country])

))