PQB04:PowerQueryBasics-Extract data from a folder contains “CSV files” automatically update new data
Channel: AAA Excel’s Power
Date: 30/11/2019

Excel Data Analysis Series: PQB “Power Query Basics”
PQB04: Extract data from folders “CSV files”
Extract data from a folder containing “CSV” files
Split columns by position
Use Csv.Document formula
Create date column considering your locale (regional settings)
Use file name as a new column in the query
Merge 3 columns to create new full date column
Load query to a pivot table and create sales report
Report will be updating automatically once you add new files to the folder

To download working files:
Excel file:
https://drive.google.com/open?id=1a9ZYOUh9XDUjdJ6wjdKht75wYjVXMuEv
CSV files: 
https://drive.google.com/drive/folders/1emXHiHjwcPeuGZAFflV9YkyjQahuokpd?usp=drive_link

watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef