7 Replies Latest reply: Nov 13, 2017 4:13 AM by thabo moeketsi RSS

    Loop through root directory (including subfolders) and list filenames of *.csv

      Hi all,

       

      I have learned how to point qlikview to a certain folder and have it list the filenames of all the CSV files found therein.

       

       

      LOAD filename() as Filename

       

      FROM

      [W:\Root\ParentFolder\*.csv]

      (txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);

       

       

      However is it possible that qlikview loops through all the csv files not only in the parent folder but also in all subfolders within the parent folder?

       

      I tried:

       

      FROM

      [W:\Root\ParentFolder\*\*.csv]

       

      But apparently it is incorrect syntax.

       

       

      Thanks in advance.