How to get directly of loaded files

[#1]

Hi all,

How to get list of all the files (excel, csv, access, etc) loaded? I also want a button to open selected file direct from qlikview.

BR,

SAK

[rustyfishbones]

Add this in the Script        filename() as FileName,

after LOAD Statement

So it would  look similar to this

LOAD

          filename() as FileName,

           Sales,

           Products

FROM filepath.xls

obviously this is just a sample!!!

[rustyfishbones]

This video will help with opening a file from Qlikview

https://www.youtube.com/watch?v=7_ScZCEBPww

Please Subscribe to my Channel, there are over 125 videos about Qlikview

[#4]

The path is getting associated with the data but I dont want it that way. I just want to get the list of files and "open" button. It will make easy if I want to edit some data in source file.

[rustyfishbones]

ok, do you own a Qlikview License?

If so I can send a file that does this.....

[rwunderlich]

Take a look at Shima's example here

http://community.qlik.com/docs/DOC-3720

-Rob

[#7]

Yes, Rob I am using it to do normal routine search on computer .

I loaded filepath() or filename() as advised by Alan above. Then I used below action as shown in picture. Now the correct selected file is opening. BUT one thing still cant get done, the right table. I have loaded data from excel. The correct excel file is opening but not the table (excel sheet). How to reach the exact source sheet/table?