I have the following code to load data from two txt file. The first file contains the history record which contains thousands of records. The second file is daily record. As the user required a up to date file so i need to load the script every 30 minutes.
The problem now is. It take a minutes to load the history file due to large number of records. May i know how do i bypass the script to load the first table.
Secondly, beside bypass the history record loading. How do i set the scheduler not to remove the history record when the loading of script runnig?
Thank you
Directory;
LOAD b_LoginID,
b_FullName,
b_UserDepartment,
b_Supervisor,
Year(b_DateOn) AS [b_Year],
FROM
\\sg\QlikView\AccessPoint\DATA\booking14c.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Directory;
LOAD b_LoginID,
b_FullName,
b_UserDepartment,
b_Supervisor,
Year(b_DateOn) AS [b_Year],
FROM
\\sg\QlikView\AccessPoint\DATA\bookingdaily.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
