topic Partial reload in QlikView

Partial reload

Tue, 12 Jan 2016 14:04:42 GMT

Hi,

I have a scenario in which I have to load two tables from SQL server. In that one table is static and the another table I have to reload in frequent interval. Is partial reload is possible with SQL server tables.

SQL SELECT *

FROM table1;

SQL SELECT *

FROM table2;

I want to reload "table2". Do we have a option to do this in Qlikview. If so please share the suggestions.

Thanks.

Re: Partial reload

Wed, 13 Jan 2016 14:21:23 GMT

Check this out: Qlik Sense Partial Reload for v2.0.x and v2.1.1

Re: Partial reload

Wed, 09 Mar 2016 15:53:04 GMT

Hi,

you can try this script.

// data that needs to be load always

// replace with first load statements

// check to identify if full reload is needed

// a full reload is needed 1 time a day

if today() > date(ReloadLastFull) or ReloadFullForce='Yes' then

set ReloadType='Full';

ELSE

set ReloadType='Partial';

set ReloadLast='Partial';

// set the last partial reload

let ReloadLastPartial = LocalTime();

// exit point in case full reload is not neeeded

exit script when ReloadType='Partial'

endif

// data that should be load only 1 time a day

// replace with second load statements

// set the variable to show how was the last reload

set ReloadLast='Full';

set ReloadFullForce='No';

// set the variable to show when was the last full load

let ReloadLastFull = Localtime();