Download Excel File: https://excelisfun.net/files/EMT1872.zip
Learn how to import multiple Csv files and append them into a table while extracting the file name and adding it to each Csv table as a new column. The Power Query User Interface methods can do this, but it creates a cluttered and messy queries. See how to streamline this process with a few lines of Power Query M Code (not hard to do). More importantly, learn how to use the let expression to avoid Custom Function syntax and define a variable that can access any scope variable in a formula with back to back Table Function.
Topics:
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
Decimal and Currency Data Type Multiplying Errors Video: https://www.youtube.com/watch?v=6420PcTGBv8&list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1&index=35
Avoid Powery Query Custom Function syntax, Use let expression to define variables and make M Code easier, each key word in Power Query Custom Functions,
#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic
#powerquery #powerquerytutorial #csv #csvimport #fromfolder #mcode #letexpression #variable #powerquerytutorial #etl