PQB10: Power Query Basics: Transform Data Merge Queries: Compare between 2 tables
Channel: AAA Excel’s Power
Date: 2020-03-09

Excel Data Analysis Series: PQB “Power Query Basics”
Data Transformation
PQB10: Merge Queries: Compare between 2 tables
1- Full outer: all values from 2 tables
2- Inner: intersection between 2 tables
3-Left anti: values in 1st table only
4-Right anti: values in 2nd  table only

To watch video PQB09:
https://youtu.be/H1wVf-orhlI
To download the excel file:
https://drive.google.com/open?id=1Nxza_0Bdjp_td47cARPDnIJv9dt3hA--
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