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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ohad

 

The simplest way I found was to use the DAX - Union (Selectcolumns(), Selectcolumns())

 

Here you can select the tables, individual columns as well as rename those columns on the fly for the Union funciton to combine the dataset together.

 

Cheers,

M