30 Replies Latest reply: Jan 12, 2017 5:00 PM by Wallo Atkinson RSS

    load files with specific names from folder through for loop

    Mark Graham

      Hi all,

       

      I'm trying to load 5 files from the folder of 1000 files.

       

      I have stored file names in vFilenames.

      vFilenames = abg, dhjk, qwe, qwee, gsdf;

       

      How can i load only these 5 files from the folder, instead of loading all files and then filtering by the filebasename()?

       

      FOR EACH File in FileList('$(vFolder)\$(vFilenames).QVD')  //Storing filenames in the variable 'File'  

            Table1:

            LOAD *

        FROM [$(File)] (qvd);

      NEXT

       

      The above is not working.

       

      Any help is highly appreciated.