PQB11: PowerQueryBasics: Merge Queries - Left Outer (Replace V-Lookup): Solve duplicate issues
Channel: AAA Excel’s Power
Date: 2020-04-18

Excel Data Analysis Series: PQB “Power Query Basics”
Data Transformation
PQB11: Merge Queries: Solve duplicate issues
Replace V-Lookup using Merge Queries (Join Kind – Left Outer) which requires 2 tables:
Transactions table or Fact table
Lookup table or dimension table
What will happen if you have duplicates in the lookup table? How to solve it inside & outside PQ? 

To Download the excel file:
https://drive.google.com/open?id=1e74c45_547iZQ_D7M35ZhqIcYksciS_r

To watch Video PQB09:
https://youtu.be/H1wVf-orhlI

To watch Video PQB10:
https://youtu.be/c5WMucMGKHc

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef