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...
Hello Eduardosa, I have already done that as stated in my origional question 🙂
Hi MartinDUK,
Then can you please show all the steps you're doing?
Something like this.
If I understoud correctly you want the content of the latest file.
For this do:
- Set Source data a Folder,
- Sort by create date,
- Add index, start with 1,
- filter index by 1
- expand file content.
Give it a try.
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