Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ppatil
Helper III
Helper III

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

ppatil_0-1639116921229.png

Table2

ppatil_1-1639116960354.png

In New merged column ,I should get only 2 columns as a result.

Thanks in advance..!!

1 ACCEPTED SOLUTION

@ppatil , 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.

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

8 REPLIES 8
Samarth_18
Community Champion
Community Champion

Hi @ppatil ,

 

You can create a new table like below:-

Table 3 = Union(table1,table2)

 

Thanks,

Samarth

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Thanks @Samarth_18 

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

@ppatil please use Append Queries.

DavidGanor_0-1639120214917.pngDavidGanor_1-1639120238535.png

 

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.

@ppatil you can change the column names to be the same,

for example:

Team name, Team initial.

 

If you'd like to distinguish between those tables afterwards (home vs away), please create an additional column for each - something like "source table" where the value should be constant "home" for table 1 , and "away" for table 2

 

 

 

 

Thank You @David-Ganor 

@ppatil , 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.

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Thank You @Samarth_18 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.