Forum Discussion

Sonne's avatar
Sonne
Icon for Helper II rankHelper II
6 years ago
Solved

merge columns from different table into 1 table

Hello, I dont find the formula for my problem . hopefully somebody can help me.  i have different tables with different fields, but 3 columns are always the same . this 3 columns i want to ha...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try like

    distinct(
    union
    (
    selectcolumns(Table1,"UPI",Table1[UPI],"ID",Table1[ID],"Personalnumber",Table1[Personalnumber]),
    selectcolumns(Table2,"UPI",Table2[UPI],"ID",Table2[ID],"Personalnumber",Table2[Personalnumber]),
    selectcolumns(Table3,"UPI",Table3[UPI],"ID",Table3[ID],"Personalnumber",Table3[Personalnumber])
    )
    )

     

    You can also use summarize in place of select columns, Small diff in syntax.

Geradav's avatar
Geradav
Icon for Responsive Resident rankResponsive Resident
6 years ago

HI Sonne ,

 

You can achieve that in the Power Query Editor with the tools available in the Ribbon.

You can use the Append Queries function in te Combine group of the Home tab.

Then you Choose Columns (Manage  Columns group in the Home tab) you want to keep and Remove Duplicates (Click on Remove Rows in the Reduce Rows group of the Home tab)

 

Let us know if that works for you.

 

Regards

 

David