Forum Discussion

Ohad's avatar
Ohad
Frequent Visitor
9 years ago
Solved

Union two tables with different columns names

Hi,   I have two tables with different names for the columns but with the same meaning and I need to union the two tables to one table with the names of the columns in table A. Do I need to create...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Ohad,

     

    In this scenario, you can also try the Append Queries option in Query Editor.:smileyhappy:

     

    1. Rename the three columns in Table B with the column names in Table A.

     

    2. Select Table A, and choose "Append Queries as New" under Home tab in Query Editor.

     

     

    Regards

thangkt's avatar
thangkt
Icon for Advocate I rankAdvocate I
8 years ago

The solution for your problem can be released by using Union and Selectcolumns Function: 

 

Union(
selectcolumns(Table A,"Opening_Date", Table A[Opening_Date], "Store_Name", Table A[Store_Name],"Store_Number", Table A[Store_Number]),
selectcolumns(Table B,"Business_Date", Table B[Business_Date], "Location", Table B[Location],"Location_Code", Table B[Location_Code])
)

You should try this way.

 

Good luck! :)