topic Re: RE:load issue in QlikView

RE:load issue

Chanty4u — Sun, 03 Apr 2016 10:09:07 GMT

Hi all,

I have issue on Loading new data into existing data.

i have script below

ZREJ_TRACWHEAT1:

LOAD WHEAT_REJ_VENDOR_CODE,

D:\..\..\TransformQVDs\ZREJ_TRACWHEAT.qvd

(qvd) where (( WHEAT_REJ_SOB_QTY<-5000) and (WHEAT_REJ_DATE<=Date('31/08/2015')) and (SOB_MOVEMENT_TYPE<>101)) ;

STORE ZREJ_TRACWHEAT1 into $(vQVDTargetDir)ZREJ_TRACWHEAT1.qvd(qvd);

Here i need to into insert the data after 31/08/2015' to till date ....

how can i add the latest data into this?

Thanks in advance.

mithilesh17 — Sun, 03 Apr 2016 10:26:24 GMT

Hi,

As you need to insert data after 31/08/2015, try using WHEAT_REJ_DATE>'31/08/2015' in where clause. Am I missing something!?

Regards,

Chanty4u — Sun, 03 Apr 2016 10:33:38 GMT

hi,

thanks.But i need that that data aswell. meand before that data also.

i hve the qvd with the data <=31-08-2015 and now new data came til aprl.

how i add this.,

Kushal_Chawda — Sun, 03 Apr 2016 10:41:55 GMT

try this, make sure that WHEAT_REJ_DATE in proper date format (DD/MM/YYYY)

WHERE WHEAT_REJ_DATE> date#('31/08/2015','DD/MM/YYYY')

if WHEAT_REJ_DATE is not in proper date format then try below

WHERE date#(WHEAT_REJ_DATE,'DD/MM/YYYY')> date#('31/08/2015','DD/MM/YYYY')

sunny_talwar — Sun, 03 Apr 2016 10:47:23 GMT

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

Where WHEAT_REJ_DATE > MakeDate(2015, 8, 31) and WHEAT_REJ_DATE <= Today();