Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I create a QVD file from one application and load the data of one specific day(2021/05/23):
[inventory_v1]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";
SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"
FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '20210523'));
Store inventory_v1 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);
Then I create another application for conducting the incremental load into the inventory_v1.qvd:
let vDAY = Date(Today()-1,'YYYYMMDD');
[inventory_v2]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";
SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"
FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));
Concatenate
Load * from [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd) where CALDAY <> $(vDAY);
Store inventory_v2 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);
What I expecting is the data will be loaded into the QVD file on a daily basis and the QVD file should have the data of everyday starting from 2021/05/23.
Yet what I got is only the data of 2021/05/23 and the data of yesterday. For example: today is 5/27, the qvd file has the data of 5/23 and 5/26 without the data of 5/24 and 5/25
Why this happened? How can I fix this?
Thanks a lot !!
HI @Aria
I create a QVD file from one application and load the data of one specific day(2021/05/23)
-- Are you loading this file daily?
Yes, through the variable: vDAY defined in the second application.
Sorry my misunderstanding. No only the second application are loading on a daily basis. The first application has only been loaded once.
Its looks like script is fine .. If you have daily schedule, I think, its work fine.
Or, you can debug the script once or check the log.
And also, Am not sure what this part will do.
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));
where can I see the log please?
Hi @Aria
in QMC-> Task->Status
You can download from here