Forum Discussion
Loading latest file from multiple sub folders
Hi, I am building a management weekly dashboard connecting to ADLS. I have to keep 12 weeks of data in perspective at any given time. Each file has a Month to date data. The data set will look like ...
- Filter your files so only releveant data is showing. For example, only XLSX file (or CSV or whatever they are), and only the folder structures you want - root\presentation for example. Call this "File LIst"
- Create a reference to that query. Call this "Latest File Name"
- Use the Group By function in Power query to group by folder and show the maxium file date.
- Create a reference to the File LIst query and call it "Final Files"
- Merge Final Files with "Latest File Name" joining the folder name and the file date. Use Inner Join
- Now you should only have a list of the last file in each of the relevant folders.
- Press Combine.
Never mind - I figured out how to combine them. I went and clicked on the column Binary and it triggerd a combine.
Thanks for your help.
Sundar
Great! Glad you got it working.