Merge Tables by Partial Value Matches - Power Query Challenge 33
Merge Tables by Partial Value Matches - Power Query Challenge 33
In this Power Query challenge, we’ll show you how to extract values from one table based on subcodes from another table. You'll learn how to filter and match subcodes, retrieve the correct values, and output the results using Power Query. This tutorial will break down the process step by step, from creating custom columns to filtering rows based on subcodes. By the end of this video, you’ll be able to confidently apply these skills in real-world data tasks, making it easier to manage large datasets across multiple tables.
Whether you're a Power Query beginner or looking to expand your skills, this video will guide you through the key concepts. Don’t forget to pause and practice along the way to get the most out of this tutorial.
Timestamps:
00:00 - Introduction to today's Power Query challenge
00:08 - Adding a custom column for extracted values
00:13 - Using Table.SelectRows to filter Table 1 by subcodes
00:52 - Retrieving the value from the filtered result
01:41 - Finishing touches: Extracting the first value from the filtered rows
🔔 Subscribe for more tutorials: / @howtolearnexcel
Links:
Challenge Author: Omid Motamedisedeh
LinkedIn: / omidmot
Youtube: / @omidbi
Website: https://www.omidbi.com/
Power Query Challenge: https://www.linkedin.com/posts/omid-m...
Download Workbook:
https://lnkd.in/gGNzd58V
'Power Query Challenges' Playlist: • Power Query: Challenges
#PowerQuery #PowerQueryChallenge #ExcelChallenge #HowToLearnExcel