Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Chanty4u
Esteemed Contributor III

RE:load issue

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.

1 Solution

Accepted Solutions

Re: RE:load issue

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

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

4 Replies
mithilesh17
Contributor II

Re: RE:load issue

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
Esteemed Contributor III

Re: RE:load issue

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.,

Re: RE:load issue

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

Re: RE:load issue

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

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