Completed
1. 00:00 Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power Query: A Cleaner Way to Import and Append CSV Files - The Transformative Power of M Code
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction
- 2 2. 00:10 excelisfun needs your help!
- 3 3. 00:16 Data Transforming Goal
- 4 4. 01:49 Start Process of importing multiple csv files and appending into a single table.
- 5 5. 02:12 Look at Power Query User Interface Method, which is very messy.
- 6 6. 02:33 Clean and prepare table of Cvs files.
- 7 7. 02:57 Proper naming convention for M Code Identifiers
- 8 8. 03:26 Extract name from file name that we need as an attribute in each csv table.
- 9 9. 04:17 Create Custom Column to transform Csv tables and add a new column that adds the file name attribute in each row of each table. See the functions. Csv. Document, Table.PromoteHeaders and Tabl…
- 10 10. 07:01 Learn how to use the let expression to define a variable when you are using back to back Table functions and you need to access data from the first of the two tables inside the back to back…
- 11 11. 09:35 Append the csv tables and choose columns in same M Code step.
- 12 12. 13:05 Summary
- 13 13. 13:17 Closing
