INCREMENTAL LOAD

[qlikview979]

Hi Experts,

Is there any Mistake? I am getting " MAXDATE" in table. not getting in VARIABLE"

T1:

LOAD ID,

     PRODUCT,

     SALES,

  DATE

FROM

(qvd);

T2:

load

max(DATE) as DATE

Resident T1;

let INC=Peek('DATE',-1,'T2');

DROP Table T1;

T3:

LOAD ID,

     PRODUCT,

     SALES,

     DATE

FROM

(ooxml, embedded labels, table is Sheet2) Where DATE>$(INC);

Concatenate

T4:

LOAD ID,

     PRODUCT,

     SALES,

     DATE

FROM

(qvd) where not exists (ID);

STORE T3 into INC.qvd(qvd);

Inner Join

T5:

LOAD ID

FROM

(ooxml, embedded labels, table is Sheet2) ;

STORE T3 into INC.qvd(qvd);

[qlikview979]

Hi Experts,

I got the output.if i create the  same Variable in end of the script i am getting max date.(Variable overrided)

Thanks for your support

Regards,

Mahesh