topic Re: How make right code increamental load? in QlikView

How make right code increamental load?

Wed, 28 Mar 2012 04:06:39 GMT

Can someone help me to repair my increamental load code? I used Oracle as a database. This is my code.

RA_CUSTOMER_TRX_ALL_TMP:

LOAD LAST_UPDATE_DATE

FROM

RA_CUSTOMER_TRX_ALL.qvd

(qvd);

Min_Max_RA_CUSTOMER_TRX_ALL:

LOAD Max(LAST_UPDATE_DATE) AS Max_TGL

Resident RA_CUSTOMER_TRX_ALL_TMP;

Let TglMax = Date(Peek('Max_TGL', 0, 'Min_Max_RA_CUSTOMER_TRX_ALL'));

DROP Table Min_Max_RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_ALL_TMP;

RA_CUSTOMER_TRX_ALL:

SQL SELECT *

FROM AR."RA_CUSTOMER_TRX_ALL"

WHERE LAST_UPDATE_DATE >= '$(TglMax)';

Concatenate

LOAD *

FROM

RA_CUSTOMER_TRX_ALL.qvd

(qvd)

where not Exists(CUSTOMER_TRX_ID);

Store RA_CUSTOMER_TRX_ALL into RA_CUSTOMER_TRX_ALL.qvd;

DROP Table RA_CUSTOMER_TRX_ALL;

Why does my code always fail when reload process reach step RA_CUSTOMER_TRX_ALL? May be trouble in format TglMax or LAST_UPDATE_DATE.

Thanks,

Danny H.

jagan — Wed, 28 Mar 2012 05:52:23 GMT

Hi,

Check whether you are getting the value in TglMax variable.

Regards,
Jagan.

Fri, 30 Mar 2012 04:01:04 GMT

I have make a variable format date like this

Let formatDate= 'YYYYMMDD'

so i must change

Let TglMax = Timestamp(Peek('Max_TGL', 0, 'Min_Max_RA_CUSTOMER_TRX_ALL'), formatDate);

I think date converter very important in increamental load.