Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to do incremental data load for dynamic month and store qvd
//Script
DB_Temp:
LOAD *,
Sales_Date,
Cust_ID,
CustName
From DBo....Sql Server
NoConcatenate
CurMnth:
LOAD Distinct
Sales_Date,
Cust_ID,
CustName
Resident DB_Temp;
Where Sales_Date>=MonthStart(Today()) and Sales_Date<=MonthEnd(Today());
Store CurMnth into Sales.qvd(qvd);
Are you facing any error while reload()??
nope, it will replace with current month while storing,
Example :
- Dec 2017 stored in QVD
- after refresh it replace with Jan 2018 instead of keeping Dec and Jan data
I believe, This will Overload automatically. But, It keeps Dec month as well. Can you create dummy data for help.
Attached for your reference. Please consider inline text as from DB.
I think, You need to load using Concatenate Like
Sales:
LOAD CustID,
Sales_Date
FROM
[TSales.qvd]
(qvd) Where Sales_Date>=MonthStart(Today()) and Sales_Date<=MonthEnd(Today());
Concatenate
LOAD CustID,
Sales_Date
FROM
[TSales.qvd]
(qvd) Where Sales_Date>=AddMonths(MonthStart(Today()),-1) and Sales_Date<=AddMonths(MonthEnd(Today()),-1);
Thanks, would you please let me know remaining month also to concatenate like this Mar 2018.....?
I believe, This is stupid way where my reply. Can you look this Do..loop ‒ QlikView