union of two tables having same column names

[Anonymous]

I have two tables with data as below

table 1 

item	item2	item3	item4	item5
a2	b2	c2	d2	e2
a3	b3	c	d3	e3
a4	b4	c	d4	e4
a5	b5	c	d5	e5

Table 2

product	product2	product3	item	item2	item3	item4	item5	product4	product5	product6
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221

I want to add/append table 1 data to table 2 , where table 2 has same columns as table 1 with addtionals columns in it

so my final output should look like below

product	product2	product3	item	item2	item3	item4	item5	product4	product5	product6
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221
111	222	333	444	555	666	777	888	999	1110	1221
null	null	null	a2	b2	c2	d2	e2	null	null	null
null	null	null	a3	b3	c	d3	e3	null	null	null
null	null	null	a4	b4	c	d4	e4	null	null	null
null	null	null	a5	b5	c	d5	e5	null	null	null

[Fowmy]

@Anonymous 

Append in Power Query: https://1drv.ms/u/s!AmoScH5srsIYgYRHURu-etKZBRdZcw?e=sK0cEc

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[lkalawski]

Hi @Anonymous,

Go to the Power Query Editor, select Table 1, go to the Home Page and click Append Queries from the Combine section. 

Choose Table 2 and click Ok. 

After this you will see the proper output.

_______________
If I helped, please accept the solution and give kudos! 😀 

[amitchandak · Accepted solution]

@Anonymous , if you append in power query this should happen

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