Managing sales data often requires combining multiple lookup tables before analysis.
In this example, Power Query automatically merges three different mapping tables into a single sales dataset.
The automation process includes:
- Loading a sales table
- Importing multiple mapping tables from an external Excel file
- Matching Sales Manager by Branch and Item
- Matching Category and Account by Item
- Matching Region and Cost Center by Branch
- Detecting unmapped records automatically
The final result creates a standardized sales dataset that is ready for reporting and analysis.
This method is useful for sales management, ERP integration, financial reporting, and enterprise data preparation.
videolink - https://youtu.be/ZzTtEUgWWfk
Download the sample file below.
You can download the zip file in [Download] page
The file name is 52.sales_mapping_automation.zip
Use the English M code provided for your dataset.
You may need to manipulate the M code under your circumstance. You consider this point and use M code
below txt file is detailed-explanation. You use M code in reference with this explanation.
---------------------------------------------------------
Need a custom automation for your Excel workflow?
I can build a tailored solution based on your data.
✔ Used in real-world business automation
✔ Saves hours of manual work
minbedata@gmail.com
You can pay via PayPal.
You don't worry about conversing with me.
My Major is an English literature, so I can speak English fluently and read, listening, writing proficiently
korean version web address (한국버전) is
<a href="https://blog.naver.com/minbe-data" target="_blank">네이버 블로그 바로가기</a>