Incremental load

Mon, 28 Apr 2014 14:25:44 GMT

Hi,all i want to increment the data to my QVD based on updated data ,it means new records will join to old ,

here based on Value_date i want to upload but problem is some record are missing when i create QVD ,now am uploading that missing record that are same Value_date ,can any one give simple script for this,

this is my Script

LOAD

Txn_Date,

Value_Date,

Description,

ChequeNo,

Year(Value_Date) as Used_year,

Month(Value_Date) as Used_month,

Day(Value_Date) as Used_day,

Debit,

Credit,

Balance

FROM

[..\Data\Qvd\sbi.qvd]

(qvd);

Re: Incremental load

its_anandrjs — Mon, 28 Apr 2014 14:34:54 GMT

Create a Max date variable like and then use it for incremental load for updated records in the database

LET vMaxDate = Peek('Value_Date',-1,'YourTableName');

YourTableName:

LOAD

Txn_Date,

Value_Date,

Description,

ChequeNo,

Year(Value_Date) as Used_year,

Month(Value_Date) as Used_month,

Day(Value_Date) as Used_day,

Debit,

Credit,

Balance

FROM

[..\Data\Qvd\sbi.qvd] (qvd);

Left Join

LOAD

Txn_Date,

Value_Date,

Description,

ChequeNo,

Year(Value_Date) as Used_year,

Month(Value_Date) as Used_month,

Day(Value_Date) as Used_day,

Debit,

Credit,

Balance

FROM

[Source Data] Where Num(Value_Date) > $(vMaxDate);

topic Incremental load in QlikView

Incremental load

Re: Incremental load