topic Re: INCREMENTAL LOAD in QlikView

INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 10:36:15 GMT

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

Re: INCREMENTAL LOAD

Peter_Cammaert — Tue, 05 Jul 2016 10:38:39 GMT

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

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 10:42:40 GMT

Hi Peter,

Sorry,

How Can i Delete other five . please tell me

Re: INCREMENTAL LOAD

Peter_Cammaert — Tue, 05 Jul 2016 10:47:29 GMT

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

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 10:48:49 GMT

Hi Peter,

I Deleted Remaining five.

Thanks

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 10:50:46 GMT

Hi Peter,

Can you Check my Script once.

Regards,

Mahesh

Re: INCREMENTAL LOAD

Peter_Cammaert — Tue, 05 Jul 2016 10:55:27 GMT

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

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 11:00:51 GMT

Hi Peter,

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

Regards

Re: INCREMENTAL LOAD

maniram23 — Tue, 05 Jul 2016 11:01:24 GMT

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

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 11:16:07 GMT

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

Re: INCREMENTAL LOAD

qlikview979 — Tue, 05 Jul 2016 15:57:19 GMT

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