From the course: Excel for Engineering Professionals
Join today to access over 23,200 courses taught by industry experts.
Importing the most recent file in a folder - Microsoft Excel Tutorial
From the course: Excel for Engineering Professionals
Importing the most recent file in a folder
- [Instructor] Remember how our solar panel production system only created a CSV file per machine per day? I showed you how to import all those files in one go. But suppose all you need is the most recent file. For example, when you want to create a report from yesterday's production. From folder to the rescue again and I'll show you how it's done. But first, let me remind you what our CSV files look like. I assume that you recall setting the query options because those dates, those were in English format and we're in America. So in order to prevent misinterpretation of our dates we set the locale that Power Query is supposed to be using to English UK. Okay, time to open that get data from file from folder again. We point it to our production data folder. And now because we need to do some file handling first and filtering, let's transform this data. So again, we're only interested in the CSV files, so filter for equals…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.