Combine Data from Multiple Excel Files with Inconsistent Column Names

Combine Data from Multiple Excel Files with Inconsistent Column Names

HomeOther ContentCombine Data from Multiple Excel Files with Inconsistent Column Names
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Goodly2022-11-15 12:45:00 Thumbnail
149,253 Views
Check out our newly launched M Language course ↗️ – https://goodly.co.in/learn-m-powerquery/

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.