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...
I do not know what the following means ...
- Add index, start with 1,
- filter index by 1
- expand file content.
I have got the file and File Path, how do i use this to import the Excel file displayed?
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