2 Replies Latest reply: Jul 26, 2017 12:49 PM by Rob Wunderlich RSS

    Incremental Load of Txt file!

    Amijit Hazarika

      Hi Qlik Community,

       

      I have a folder which contains text files. Every week a new text file comes up.

       

      As of now, the QVD builder fetches data from all the files from that folder.

       

      I am thinking to do incremental load as I am concerned with the new file which comes every week. Other files are not at all touched.

       

      As of now the script is;

       

      Load

      A,

      B,

      C, ....upto 22 fields

      Left(Subfield(Filename(),' - ',2),10) AS WeekCommencing

      FROM [lib://01_Firm_MI/Data Inputs & Outputs\People - Headcount\Input\*.txt]

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

       

      Can anyone help me how do I get an incremental load done here?

       

      Thanks

      Amijit