Power Query: A Cleaner Way to Import and Append CSV Files - The Transformative Power of M Code

1. 00:00 Introduction
2. 00:10 excelisfun needs your help!
3. 00:16 Data Transforming Goal
4. 01:49 Start Process of importing multiple csv files and appending into a single table.
5. 02:12 Look at Power Query User Interface Method, which is very messy.
6. 02:33 Clean and prepare table of Cvs files.
7. 02:57 Proper naming convention for M Code Identifiers
8. 03:26 Extract name from file name that we need as an attribute in each csv table.
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 Table.AddColumn
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 Table.AddColumn functions.
11. 09:35 Append the csv tables and choose columns in same M Code step.
12. 13:05 Summary
13. 13:17 Closing