Incremental load error

[yadav_anil782]

Dear All ,

i'm using this script for incrimental but this script giving error and i'm stuck to find error , if can anybody help then plz help to find the error

LOAD USER_NAME,

     USER_ID,

     LOGIN_TIME,

     LOGIN_COUNT

FROM

(qvd);

last_updated_date:

LOAD

max(LOGIN_TIME) as max_date

Resident xx_login_rev_view;

let vmax =Peek(max_date,0,'last_updated_date') ;

drop Table xx_login_rev_view;

incrimental:

LOAD

USER_NAME,

     USER_ID,

     LOGIN_TIME,

     LOGIN_COUNT

FROM APPS."XX_LOGIN_REV_VIEW"

where LOGIN_TIME > $(last_updated_date);

Concatenate

LOAD USER_NAME,

     USER_ID,

     LOGIN_TIME,

     LOGIN_COUNT

FROM

(qvd);

store incrimental into;

drop Table incrimental;

[tresesco]

Did you try what I suggested above?

Try putting a space after into, like:

store incrimental into [C:\Qlikview\QlikView Project\gl\qvd\xx_login_rev_view.qvd];

[Mark_Little]

18-11-2015 17:09:57: 0064  where LOGIN_TIME > ''

18-11-2015 17:10:11:       4 fields found: USER_NAME, USER_ID, LOGIN_TIME, LOGIN_COUNT, 0 lines fetched

Your variable isn't being populated

[#4]

Hi

you need to use single quotes around field name in peek function while creating a variable 

let vmax =Peek('max_date',0,'last_updated_date') ;

VC.

[Mark_Little]

I would run the below only see what is populated in the the table (last_update_date)and variable

LOAD USER_NAME,

     USER_ID,

     LOGIN_TIME,

     LOGIN_COUNT

FROM

(qvd);

last_updated_date:

LOAD

max(LOGIN_TIME) as max_date

Resident xx_login_rev_view;

let vmax =Peek(max_date,0,'last_updated_date') ;

Trace $(vmax)

drop Table xx_login_rev_view;

Mark