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;





      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?