Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI Amijit,
Please Find below therad as well as steps given :
Incremental reload and store into QVD file
Thanks,
Arvind Patil
For text files, incremental reload is incredibly simple. Just add the "BUFFER (incremental)" prefix to the LOAD statement. That's all it takes.
-Rob