Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Search folders inside Apps

What is the function of 'Search' sub folder, present inside the 'Apps' folder? Inside this folder I can see my apps and lots of files with encrypted names. What is the use of it and what does it do?



Thanks in advance!

Tags (1)
1 Reply
Honored Contributor

Re: Search folders inside Apps

Set vConcatenate = ;

sub ScanFolder(Root)

          for each FileExtension in 'csv' /* put your extension that you are searching for */

                    for each FoundFile in filelist( Root & '\*.' & FileExtension)



                              LOAD *, '$(FoundFile)' as SourceFile

                              FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 2 lines);

                              Set vConcatenate = Concatenate;

                    next FoundFile

          next FileExtension

          for each SubDirectory in dirlist( Root & '\*' )

                    call ScanFolder(SubDirectory)

          next SubDirectory

end sub

Call ScanFolder('your_directory') ;