Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merge Two Tables

Hi Community..!! I want to merge two columns in such away that table2 data should come below to the table1 data Table1 Table2 In New merged column ,I should get only 2 columns as a re...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Anonymous , For achieving this in power query you have to first rename column name of your table 2 and make it same as table 1 then follow what David-Ganor has suggested. You will get 2 column only.

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

You can create a new table like below:-

Table 3 = Union(table1,table2)

 

Thanks,

Samarth

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Samarth_18 

    But can u please tell me , how can we do it in Power Query?

    • David-Ganor's avatar
      David-Ganor
      Resolver II
      4 years ago

      Anonymous please use Append Queries.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi David-Ganor 

        If I use append then its creating four columns , that I dont want.

        Result should comes in 2 coulmns only.

        U can read my first question carefully for better understanding.