topic Re: Increase speed of script in QlikView

Increase speed of script

vchuprina — Mon, 08 Aug 2016 11:04:34 GMT

Hi All,

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,

Time:

LOAD

Num(FileTime()) AS CreatedTime

From

[$(vFile)]

($(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.

Re: Increase speed of script

Gysbert_Wassenaar — Mon, 08 Aug 2016 11:29:34 GMT

You're using a straight forward load statement with no restrictions so it will load run FileTime() once for every record. Try this instead:

Time:

FIRST 1

LOAD

Num(FileTime()) AS CreatedTime

From

[$(vFile)]

($(vExcel), no labels, table is [$(vSheetName)])

;

LET vTime = Peek('CreatedTime', 0, 'Time');

DROP Table Time;

Re: Increase speed of script

vchuprina — Mon, 08 Aug 2016 11:39:33 GMT

Thank you, Gysbert. Now script works much more faster.