Merge or Append

[Framboosje1]

Hi i have a problem how to merge or append 3 tables without a relationship

see below the issue and the sample data in pbix

https://drive.google.com/file/d/1367Qe8oG0HOqza1ESkxxDnFaqn6-9hIP/view?usp=sharing 

[v-frfei-msft]

Hi @Framboosje1 ,

We should change the column name from "DEPARTMENT" to "DEPARTMENT NAME" for the US table. Then we can append the all the tables as new as below.

After that, remove the COURSE column to get the excepted result. For more details, please check the pbix as attached.

[Anonymous]

Hi

Append will append the records at the end:

Merge will need a relationship, even when it is a left outer join.

What is your real question?

If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[Framboosje1]

i want the result table as the result regardless what the approach will be. it doesn't matter for me whether its merging,appending or something else.