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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

ayami123's avatar
ayami123
Icon for Helper I rankHelper I
9 years ago

I want to use union because I'm not allow to edit and create new excel file.  =_=
that's why i want to use union
is there anyway I can use Union in PowerBI?