From the course: Advanced Power Query
Join today to access over 24,900 courses taught by industry experts.
Solution: Remove junk column names
From the course: Advanced Power Query
Solution: Remove junk column names
(upbeat music) - [Instructor] I am sure you were able to solve the problem that I gave you in the last video, but in case you weren't, that's totally all right. We will discuss two approaches to solve this problem. One is going to be a mix of user interface and M approach. The other one is going to be a pure play M approach. You're going to have a lot of fun and you'll learn a lot. Let's start. Okay, let's just start by loading this data into Power Query. This has already been converted into a table, so I'm going to go over to the data tab and here I have from table range. Once the data is loaded into Power Query, you're going to see that this is the change type step that is automatically coming in at the moment, which I don't want to use it at the moment, so I'll get rid of that. Now for just a quick second, let's just try removing columns manually to see what code does Power Query generate, and can we tweak that code to modify and make our query dynamic. So to begin with, I'm going…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.