Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table

Описание: Download Files:

Start File: https://excelisfun.net/files/EMT1353S...

Finish File: https://excelisfun.net/files/EMT1353F...

See how to use the Power Query (Get & Transform) Inner Join Merge Feature to Extract Records (Data) from an Excel Table based on Criteria from cells in an Excel sheet (Criteria in a Parameter Table):
1. (00:16) Introduction
2. (01:49) Convert Criteria for Data Extract to an Excel Table (Parameter Table), including adding Data Validation List to the cells in the Table.
3. (03:27) Import the Two Excel Tables into Power Query (Get & Transform) using From Table button
4. (04:54) Use Merge feature with an Inner Join to merge tables and extract desired records (data). Trick thanks to pmsocho at YouTube.
5. (08:15) Test with a single Condition
6. (09:10) Test with two Criteria and Refresh to get Extract Records. See an OR Logical Test
7. (09:59) Compare Advanced Filter Method of Extracting Records using an OR Logical Test
8. (12:00) Summary

Reference Videos:
Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet
   • Excel Magic Trick 1346: Array Formula: Spl...  
Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product
   • Excel Magic Trick 1347: Power Query Functi...  
Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records
   • Excel Magic Trick 1349: Power Query with I...  
excel-654 - Power Query - zapytanie z parametrami dotyczącymi jednej kolumny
   • excel-654 - Power Query - zapytanie z para...  
pmsocho
   / @pmsocho  
Thanks to pmsocho at YouTube