Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Adam,
Can you start from here? Loading new and updated records with incremental load ‒ Qlik Sense
Regards,
Andrey
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;