topic Re: Incremental data load for dynamic month in QlikView

Incremental data load for dynamic month

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: Incremental data load for dynamic month

Anil_Babu_Samineni — Mon, 29 Jan 2018 13:46:56 GMT

Are you facing any error while reload()??

Re: Incremental data load for dynamic month

karan_kn — Mon, 29 Jan 2018 13:50:59 GMT

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

Re: Incremental data load for dynamic month

Anil_Babu_Samineni — Mon, 29 Jan 2018 13:59:56 GMT

I believe, This will Overload automatically. But, It keeps Dec month as well. Can you create dummy data for help.

Re: Incremental data load for dynamic month

karan_kn — Mon, 29 Jan 2018 14:06:43 GMT

Attached for your reference. Please consider inline text as from DB.

Re: Incremental data load for dynamic month

Anil_Babu_Samineni — Mon, 29 Jan 2018 15:09:05 GMT

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);

Re: Incremental data load for dynamic month

karan_kn — Mon, 29 Jan 2018 16:08:52 GMT

Thanks, would you please let me know remaining month also to concatenate like this Mar 2018.....?

Re: Incremental data load for dynamic month

Anil_Babu_Samineni — Tue, 30 Jan 2018 00:33:56 GMT

I believe, This is stupid way where my reply. Can you look this Do..loop ‒ QlikView