topic Re: Create Filename list table from folders and subfolders in QlikView

Create Filename list table from folders and subfolders

Wed, 17 Jun 2015 02:55:20 GMT

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)

Re: Create Filename list table from folders and subfolders

Siva_Sankar — Wed, 17 Jun 2015 03:44:44 GMT

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

Re: Create Filename list table from folders and subfolders

Siva_Sankar — Wed, 17 Jun 2015 03:52:40 GMT

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

Re: Create Filename list table from folders and subfolders

Wed, 17 Jun 2015 03:58:41 GMT

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

Re: Create Filename list table from folders and subfolders

Wed, 17 Jun 2015 04:00:23 GMT

I will try these shankarece..

thanks you very much!!

Re: Create Filename list table from folders and subfolders

Wed, 17 Jun 2015 06:26:31 GMT

Hi Shankarece!

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