Merge Table

[unnijoy]

I have two Tables like below. Now i need to merge both table and create a new table. How to do this. 

Termintation HC	EMPID	F_Name	M_Name	L_Name	DOJ	LWD
Active HC	EMPID	F_Name	M_Name	L_Name	DOJ	Tenure	Age Bucket

New Table

EMPID

F_Name

M_Name

L_Name

DOJ

Tenure

Age Bucket

LWD

[Anonymous · Accepted solution]

Hi  @unnijoy ,

Did you try unchecking "Enable parallel loading of tables" under Options, Data Load?

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@unnijoy , have you tried to use merge in power query?

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[unnijoy]

hi @amitchandak ,

yes i followed the same steps. Table 1 contain 63 lack row of data and Table 2 contain 2 lack Row of data. When i merge it is showing as loading and till now its is showing as it had loaded 149700500 rows loaded and its still loading. How is this possible. Did i miss somthing.

[Anonymous]

What type of join did you use? Can you post screenshot of the merge queries dialog box?

[unnijoy]

i use left outer. Below is the screen shote.