Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Filename list table from folders and subfolders

I would like to ask how to create filename list table that was save in folder and subfolders then if you click one of the filename it will open.

Thank you very much for your support.

jeff

(Qlikview Newbie)

1 Solution

Accepted Solutions
Siva_Sankar
Master II
Master II

Find the attached qlikview document.

In that key in your path in the directory and reload. It will list the files once reload is completed. select the file you want and  press open doc button

View solution in original post

5 Replies
Siva_Sankar
Master II
Master II

Use the below code to get the list of files from the folder

set vRoot = 'C:\myfolder';//your folder path

FOR Each Ext in 'txt'

FOR Each File in filelist ('$(vRoot)'&'\*.'&Ext)

Load '$(File)' as Name, FileSize( '$(File)' ) as

Size, FileTime( '$(File)' ) as FileTime

autogenerate 1;

next File

next Ext

Siva_Sankar
Master II
Master II

Find the attached qlikview document.

In that key in your path in the directory and reload. It will list the files once reload is completed. select the file you want and  press open doc button

Not applicable
Author

Hi Shankarece,

Thank you very much for your prompt reply.

Is it possible if I select a filename in the list, it will open the selected file?

Hope for your kind consideration.

Thanks and regards,

jeff

Not applicable
Author

I will try these shankarece..

thanks you very much!!

Not applicable
Author

Hi Shankarece!

Thank you very much. It's working with button!