2 Replies Latest reply: May 20, 2013 4:07 AM by Tarun Verma RSS

    Assign Multiple values to variable

      Dear QLikview Experts,

       

      I have to load data from multiple files which have timestamp at the end of their names

       

      Presently we are using

      SET vActualFileLoc = "Actual_MAINFILE*.csv'";

       

      Files are like

      ACTUAL_MAINFILE_201101*.csv'";

      ACTUAL_MAINFILE_201102*.csv'";

       

      and so forth till current month.

       

      I am loading it as

       

      For

      each vActualBW in filelist($(vActualFileLoc))

      LOAD *FROM

      $(vActualBW)

      (
      txt, utf8, embedded labels, delimiter is '|');

      Next

       

       

      I need to change this so that I start the loading from 201206 month. I tried and found that CONCAT function could be of help here. But when I tried, it was not working.

       

      Pls guide here.