Check out our newly launched M Language course ↗ https://goodly.co.in/learnmpowerquery/
In this video, we will learn how we can combine data from multiple excel files which contain different column names. We will also learn how to create a mapping table & plug that as the rename the inconsistent column names!
===== ONLINE COURSES =====
✔ Mastering DAX in Power BI
https://goodly.co.in/learndaxpowerbi/
✔ Power Query Course
https://goodly.co.in/learnpowerquery/
✔ Master Excel Step by Step
https://goodly.co.in/learnexcel/
✔ Business Intelligence Dashboards
https://goodly.co.in/learnexceldash...
===== LINKS =====
Blog https://www.goodly.co.in/blog/
Corporate Training https://www.goodly.co.in/training/
Need my help on a Project https://www.goodly.co.in/consulting/
Download File https://goodly.co.in/combinedatafro...
===== CONTACT =====
Twitter / chandeep2786
LinkedIn / chandeepchhabra
Email [email protected]
===== CHAPTERS =====
0:00 Intro
0:20 Explanation of the Problem & Data
1:27 Understanding the Logic
3:55 Getting all the Column Names
8:01 Creating the Mapping Table in Excel
9:28 Combining the Data & plugging in the Mapped Table
15:47 Testing the Query
17:41 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my fulltime venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Source: https://goo.gl/fh3rEJ
Official After The Fall YouTube Channel Below
https://www.youtube.com/channel/UCGQE...
License: Creative Commons AttributionShareAlike 4.0 International (CC BYSA 4.0)
Full license here: https://creativecommons.org/licenses