Partial reload

[#1]

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.

[#2]

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

[#3]

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();