Import two tables from two DB as UNION

[shaya]

Hello
I want to compare data between two companies, 
two companies are from two DB (same server, and the same structure) .
I want to import tables as UNION.
Is it possible and how?
Thanks
(In QLICK VIEW this is possible)

[shaya]

Hello Tom
At first, I was looking for the MERGE in SQL, it was my mistake, 
after that I found it in the help of POWER BI thanks to you.

[TomMartens]

You're welcome!

[TomMartens]

It is also possible in Power BI

Before using Append to create one table with records from both tables create a custom column "Source" with values to mark the records with their source

[sokg]

Do you know the difference  between merge and append?

[shaya]

did not know before, I read about MERGE, I did not find APPEND
1. Still if I write a query, I am in the DB environment of one company.
2. I also do not need the MATCHED, because I want all records, the only field that is changed is the company name.

The question is, how can I see the two tables together

And thanks again

[shaya · Accepted solution]

Thank you all

[TomMartens]

Step 1

Connect to your table from company 1 and make all your transformations

Step 2

Connect to your table from company 2 and make all your transformations

Step 3

Go to Query Editor

Step 4a

Mark one of the Queries and in the home tab

Step 4b
choose the appropriate Append option

Step 4c

choose the table to append

Hope this helps