Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adambrian
New Contributor II

Qlik Sense Partial Reload

Hi guys,

I dont know  how to use partial reload, can someone help me.

I need to reload data every 5 hours with same table and field. I already set automatic load in qlik sense server every 5 hours, how can i just load or add only data after last reload. Do you have idea to help me this one. Can you give example in app so i can see well the process..

Thanks,

Adam

2 Replies
ahaahaaha
Honored Contributor

Re: Qlik Sense Partial Reload

Hi Adam,

Can you start from here?  Loading new and updated records with incremental load ‒ Qlik Sense

Regards,

Andrey

adambrian
New Contributor II

Re: Qlik Sense Partial Reload

Hi ahaahaaha,

Thanks for your help, can your help me to use "Insert only (no update or delete) ". I want to use this type but i dont know to use it. I called data using ODBC.

Example:

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(BeginningThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;

STORE QV_Table INTO File.QVD;

Community Browser