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




      and so forth till current month.


      I am loading it as



      each vActualBW in filelist($(vActualFileLoc))

      LOAD *FROM


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




      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.