PQB11: PowerQueryBasics: Merge Queries - Left Outer (Replace V-Lookup): Solve duplicate issues
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=1e74...
To watch Video PQB09:
• PQB09: Perform VLOOKUP in Power Query...
To watch Video PQB10:
• PQB10: Power Query Basics: Transform ...
To watch the full playlist
• PQB :Power Query Basics
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef