Discussion board where members can get started with Qlik Sense.
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?
Please Find below therad as well as steps given :
Incremental reload and store into QVD file
For text files, incremental reload is incredibly simple. Just add the "BUFFER (incremental)" prefix to the LOAD statement. That's all it takes.