RE:load issue

[Chanty4u]

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]

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]

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]

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 · Accepted solution]

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

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