Forum Discussion
How do I Use Text from Cell Drill Down as Data Source and File location.
I have files in a Network Folder and have written a query to get the list of files from a Folder. Filtered the File name for the relevent file. Filtered the Latest file. Drilled down in the Cel...
MartinDUK let me breakdown the steps for you.
So starting with accessing data on a Folder:
- Sort by creation date
- Add index
- Filter by 1 ( to get latest file)
- Get file content
Regards
I found easy to understand and follow instructions here....
Thankyou to those who offered advice, much appreciated 🙂
https://www.youtube.com/watch?v=pHDRKNjuwmU&ab_channel=BI-LingualAnalytics