Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
elenarelinque
Creator
Creator

Incremental Load - QVD Generation

Hi! I have a data base that only keeps records of the last 6 months. I need to store this records in a QVD so I can keep them even when those records are not in the data base anymore. I guess that I should do an incremental load every day, storing the records for the new day in the qvd but I don't know how to do it.

This is my script and the date that I need to use is in the field "ts_ins":

LIB CONNECT TO 'Microsoft_SQL_Server_D-STORES1256QLEXPRESS';

Dima:
LOAD id,
MissId,
Skid,
Cont_Code,
Destination,
Description,
Quantity,
MissionDatas,
ts_created,
ts_running,
ts_end,
ts_ins as Fecha_Comun,
ts_read,
Date(MonthStart("ts_ins"),'MMM-YY') as Month_Regulador_Dima,
'AUTOMATICO_PTL' as COD_MAQUINA_REG_DIMA;

[Hist_Missions]:
SELECT id,
MissId,
Skid,
"Cont_Code",
Destination,
Description,
Quantity,
MissionDatas,
"ts_created",
"ts_running",
"ts_end",
"ts_ins",
"ts_read"
FROM "db-Strugal".dbo."Hist_Missions"
where Destination = 'B04';

Thank you in advance.

1 Reply
Jack_Guo
Support
Support

Hi @elenarelinque ,

This post may help you to understand the incremental reload to qvd. You may refer to ASHFAQ's attachments.

https://community.qlik.com/t5/QlikView-App-Dev/Incremental-Load-Script/td-p/659672