Forum Discussion
Merging Tables From Two Different Data Sources With DIFFERENT Schemas
Dear All, Need some help with merge two different data sources as seen below into one singular table for analysis purpose. In short, the differences between 1 and 2 are such that the...
Starstorm , Merge in Power query should help
Or may be one merge and then append
Append Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15
Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16
Append and Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thank you, but is there a way just solely to be performed without using a power query?
How does merge and append resolve the duplication?