1 Reply Latest reply: Mar 10, 2017 7:57 AM by Vineeth Pujari RSS

    Load multiple fine in qilik

    vir vir

      We having a 5 files generated daily in a folder:-

      ET<YYMMDD>

      AT<YYMMDD>

      GT<YYMMDD>

      KT<YYMMDD>

      MT<YYMMDD>

      Here we need to load all these files in a one shot instead of writing multiple load statement.

      And in another situation we need to check that file is available in the folder or not as not necessary that all these files should available daily.

       

       

       

       

      LOAD *

      FROM

       

       

      [D:\QlikView\SourceDocuments\InputFiles\ET170310.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

        • Re: Load multiple fine in qilik
          Vineeth Pujari

          as below

           

          LOAD *

          FROM

          [D:\QlikView\SourceDocuments\InputFiles\*.csv]

          (txt, codepage is 1252, embedded labels, delimiter is ',', msq);


          if you want to load files for a particular date then create a variable to use

          example:

          let vDate = DATE(Today(),'YYMMDD');



          LOAD *

          FROM

          [D:\QlikView\SourceDocuments\InputFiles\*$(vDate).csv]

          (txt, codepage is 1252, embedded labels, delimiter is ',', msq);