Forum Discussion

Framboosje1's avatar
Framboosje1
Frequent Visitor
6 years ago

Merge or Append

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/vi...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

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.