PQB09: Perform VLOOKUP in Power Query using Merge Queries - Left Outer Join Type
Channel: AAA Excel’s Power
Date: 2020-02-14

Excel Data Analysis Series: PQB “Power Query Basics”
Data Transformation
PQB09: Merge Queries - Merge data from 2 Tables
In this video:
Use merge queries to bring product data into sales - V-lookup function
Join kind: Left outer
In the previous video: (PQB08)
Append sales data from 3 different tables into 1 table
For accurate append we must unify: 
(Number of columns – header name – data type)
To watch PQB08
https://youtu.be/a-C-sccF-TA

To download the working files:
CSV: https://drive.google.com/open?id=18BJt2FIZRPlPIay-P92dCZB3nQ0AmqoU
Excel: https://drive.google.com/open?id=1ygaBTfUtBtClzm4clnSlhFZ1qtKEFuEz

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