Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

qlikview979
Valued Contributor

INCREMENTAL LOAD

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

10 Replies

Re: INCREMENTAL LOAD

Can you please delete the other five discussions with the same title? They seem identical to this one. Thanks.

qlikview979
Valued Contributor

Re: INCREMENTAL LOAD

Hi Peter,

Sorry,

How Can i Delete other five . please tell me

Re: INCREMENTAL LOAD

Open each discussion and check the corresponding entry in the Actions Menu on the right.

qlikview979
Valued Contributor

Re: INCREMENTAL LOAD

Hi Peter,

I Deleted Remaining five.

Thanks

qlikview979
Valued Contributor

Re: INCREMENTAL LOAD

Hi Peter,

Can  you Check my Script once.

Regards,

Mahesh

Re: INCREMENTAL LOAD

If you change this piece:

T2:

load

max(DATE) as DATE

Resident T1;

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

DROP Table T1;

into this:

T2:

Noconcatenate

load

max(DATE) as MAXDATE

Resident T1;

let INC=num(Peek('MAXDATE'));

DROP Table T1;

Then what do you get?

Best,

Peter

qlikview979
Valued Contributor

Re: INCREMENTAL LOAD

Hi Peter,

I am getting number format. that one also "previous of max date(second max date).

Regards

maniram23
Contributor II

Re: INCREMENTAL LOAD

Hi,

T1:

LOAD ID,

     PRODUCT,

     SALES,

  DATE

FROM

(qvd);

T2:

load *

Resident T1 order by DATE;

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(T3)

T4:

LOAD ID,

     PRODUCT,

     SALES,

     DATE

FROM

(qvd) ;

STORE T3 into INC.qvd(qvd);

qlikview979
Valued Contributor

Re: INCREMENTAL LOAD

Hi Experts,

Can Any One Give Solution?  first time not getting "max date"? where i go for reload second time i am getting "max date" in Variable