Forum Discussion

sbenzaquen's avatar
sbenzaquen
Icon for Helper I rankHelper I
5 years ago
Solved

append/calculate two different tables

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: ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    sbenzaquen ,

    Try like this example

    a new table 

    Distinct(union (

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

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

    ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sbenzaquen ,

Try like this example

a new table 

Distinct(union (

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

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

))