Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion 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
Highlighted

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

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

View solution in original post

4 Replies
Highlighted
Partner
Partner

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,

Highlighted
Champion III
Champion III

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

Highlighted
MVP
MVP

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

Highlighted

May be

Concatenate(ZREJ_TRACWHEAT1)

LOAD FieldNames

FROM Source

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

View solution in original post