Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental Load on QlikSense

Hello Everyone,

Is there a way to run an incremental load on Qliksense desktop, or is this service only available for Qlik View. I am new to the program and would appreciate any guidance and help.

Best Regards,

Rodrigo

3 Replies
Not applicable
Author

Hi Rodrigo,

Even we can do incremental loads in Qlk Sense as well.

There is no differences between Qlik Sense and Qlik View in loadings

Thanks

Mahesh

ahaahaaha
Partner - Master
Partner - Master

OmarBenSalem

You can always perofmr incremental load:

One example of doing:

//this table.qvd was already loaded once with load * from table where date <today(); so initially it contains all data prior to today

Table:

LOAD * FROM [source\table.qvd] (qvd);

Concatenate:

// load table today

LOAD *

FROM source;

WHERE date=today();

store table into [source\table.qvd](qvd);

This way, in the next reload ; we'll have the first step; load all data untill today(); then load only today()+1 (tomorrw) and concatenate it with the exisiting table.qvd and so on

Hope this helps.

Omar,