In this tutorial we will add some logic to this method that will look at a folder but only load the most recently added item from that folder.ĭata for this tutorial is located this link Monthly Data Zip File. My previous post (found here) talks about loading data from a folder.
Well in this tutorial I’ll show you how to remove some of the pain of that continual data loading process by loading new data from a folder. That stupid report shows up again, and now you have to lug all that data from file to file and begrudgingly you sent out your report. Still enamored by your awesome report, you send it out again knowing you have saved your self so much time not having to do the analysis or creation of your reports over and over again. Then tomorrow when the data comes to you again you repeat the same process over again. You pat your self on the back and happily send out your fantastic report to everyone you know. Being the data savvy person that you are you’ve spent some time working in excel to make a template where you can copy your new data into and then automatically all your equations and graphs magically work. You get a data file from an automated system, it has the same number of columns but the data changes for every new file.
0 kommentar(er)
