| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Goodly | 2022-11-15 12:45:00 |  149,253 Views |
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/learn-dax-powerbi/
️ Power Query Course-
https://goodly.co.in/learn-power-query/
️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/
️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dashboards/
===== 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/combine-data-from-multiple-excel-files-with-inconsistent-column-names-in-power-query/
===== CONTACT =====
Twitter – https://twitter.com/chandeep2786
LinkedIn – https://www.linkedin.com/in/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 full-time 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 Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: https://creativecommons.org/licenses
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
