Discussion Board for collaboration on QlikView Scripting.
I want to implement incremental reload because we get a lot of files and it's take a lot of time to load all files each time.
In script I create table to load filetime,
Num(FileTime()) AS CreatedTime
($(vExcel), no labels, table is [$(vSheetName)])
LET vTime = Peek('CreatedTime', 0, 'Time');
DROP Table Time;
but I can't understand why script checked each line in sheet, for example if file have 36.507 lines, script load all of them.
Go to Solution.
You're using a straight forward load statement with no restrictions so it will load run FileTime() once for every record. Try this instead:
Thank you, Gysbert. Now script works much more faster.