How join same tables.

[Fidzi8]

Hi,
I have two input tables and I need just five columns from each table (every table has different number columns and different position columns). I edit both tables that tables had same header.

Then I need join those tables to one table. How I join same tables create in power query. 

Thank you
Ondřej

[amitchandak · Accepted solution]

@Fidzi8 , Check if this can help

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

[V-pazhen-msft · Accepted solution]

@Fidzi8 

Or create a calculated Table with UNION.

New Table = Union(Table1,Table2)

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Fidzi8 , Check if this can help

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