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,
Set data source as being a Folder, and from this step do all the transformations you require to select the latest file.
Regards,
Eduardo
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?
