Conclusion

3 minutes
Share the link to this page
Copied
  Completed
A final wrap of what was covered by the course with a brief overview of what was left uncovered.

Transcript

Congratulations, you've completed my course introducing getting transformed. With this introductory course, I've walked you through a large portion of the base capabilities that are built into the tool, and I've shown you some different ways to apply it against different Excel challenges. Even alone, these functions open many data access and query capabilities. However, we've still only scratched the surface of getting transformed. For many of you, these basic features may be all you need to use getting transformed for your work. For others, you may be looking to move into more advanced computations, or even make the leap to Power BI, in which case you'll want a deeper grasp of the underlying pieces to the M language, which I've avoided in this course.

Understanding and editing the background m language will allow you significantly more control over the process and results than the GUI based editor. allows. And since the GUI also writes code for you, learning how to apply the different functions can be surprisingly easy. In this brief example, here, I have some result down the line that needs to calculate off of either the Z primary, secondary, or tertiary tables. I set up four tables to manage this, with the first being a selection table, similar to what we've done in the course using merge. But in this case, a merge cannot select a different table based upon an input.

I'm going to dive into the underlying code and use the index value from the selection table to specify how to edit a parameter that I then feed into the source data command that was originally created using the from table Excel command. Consider the uses for something like this. I could have a set of us Europe and Asian database definitions that would allow you to quickly and easily change which SQL Server all of the queries In a workbook are pointing to, or otherwise specify a series of financial model scenarios that feed into a get and transform powered financial modeling computation. But that still looks at kitten transform as different encapsulated iterative queries. But yet, there's still much more to the syntax. You may recognize this data from chapter five, except now I've split it into three different tables.

For this demonstration, I'm going to use one of the tables to build a function to use against the other tables. The first part of this is a quick stroll down memory lane, as I applied different GUI based functions to clean the data and then split it into columns. But now I'm going to open the advanced editor and change everything. Well, that's an exaggeration, not everything, in fact, almost nothing at all. With the addition of only a few parentheses, two lines of code, and the replacement of the dirty with my parameter table name, I've created a whole new function I can test the function by putting different names in and seeing the results when I invoke it, and I can even use it in writing m code elsewhere in my workbook. So for example, I can create a blank new query, go to the advanced editor and enter three clean data commands to pull the data in.

I can then use the gooeys append command and edit it in the advanced editor to then combine the results together. I hope this course has helped you learn how to use an apply getting transform and some useful ways. And as I've briefly demonstrated here, there's still plenty more to learn. Thank you for taking my course. And I hope you consider taking my follow up course on advanced getting transformed topics.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.